Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #44.2K
|
Already typed my post once, having to do it again.... With the following code in MS SQL 2K: SELECT Users.*, Trainers.FirstName AS TFirstName, Trainers.Surname AS TSurname, Trainers.DisplayAs AS TDisplayAs, Trainers.DIRealname AS TDIRealname, Trainers.UserID AS TUserID, Trainers.TrainerExpiry AS TTrainerExpiry FROM Users LEFT OUTER JOIN Users AS Trainers ON Users.UserTrainerID = Trainers.UserID …
|