select a.lastname as creator ,b.lastname as Updater
from tbl_user a, tbl_user b, tbl_news c
where c.creatorId = a.userId
and c.updaterId = b.userId
-----Original Message-----
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 7:32 AM
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]
