In the tbl_user table I have 3 columns (among others): userId, firstName,
lastName
In tbl_news I have two columns (among others): creatorId, updaterId both of
which relate back to the tbl_user table.
In a query, how would I get the first name and last name of both the creator
and updater?
I can JOIN and get one, but how to you differentiate between the creator and
updater names when joining?
Thanks!
Mike
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
