Already typed my post once, having to do it again....
With the following code in MS SQL 2K:
Trainers.FirstName AS TFirstName,
Trainers.Surname AS TSurname,
Trainers.DisplayAs AS TDisplayAs,
Trainers.DIRealname AS TDIRealname,
Trainers.UserID AS TUserID,
Trainers.TrainerExpiry AS TTrainerExpiry
LEFT OUTER JOIN Users AS Trainers
ON Users.UserTrainerID = Trainers.UserID
I receive the following error:
Ambiguous column name 'Username'
(Username IS a field in the Users table for verification)
It works fine when I use it in enterprise manager for testing, but when called in an asp page, it returns the error.
It's doing my head in at the mo, so if anyone has any idea why it might be doing this I'll be greatly appreciative!
Thanks in advance
:?: :!: :?: