Hi,

Try something like this:

SELECT  U1.User_Name
,               U2.User_Name
,               B.Booking_Date 
FROM            USER U1
,               USER U2
,               BOOKING B 
WHERE   B.Booking_Creator = U1.User_ID 
AND             B.Booked_User = U2.User_ID'

Jack



-----Original Message-----
From: Shaun [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 06, 2003 11:24 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Selecting two names from a table


Hi,

I have a table called Bookings and a table called User. Bookings are
created and hold the User_ID of the User who created it
(Booking.Booked_User) and the User who will be going on the booking
(Booking.Booking_Creator). How can I create a report that lists both
users on each row. If I do 'SELECT U.User_Name, B.Booking_Date FROM
WMS_User WHERE B.Booking_Creator = U.User_ID AND B.Booked_User =
U.User_ID', then the query returns no data. So for each row in the table
I need to somehow select 2 names from the user table based on 2
different User_ID's held in the Bookings table. Any help would be
greatly appreciated.


Thanks for your help

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to