you could potentially alias the tables, something like
SELECT *
FROM news, users creator, users updater
WHERE news.creatorid = creator.userid
AND news.updaterid = updater.userid
-----Original Message-----
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 13:32
To: CF-Talk
Subject: OT: SQL Assistance
I have two tables: tbl_user and tbl_news
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]
