subject:"RE\: \[PHP\-DB\] Selecting two names from a table"

RE: [PHP-DB] Selecting two names from a table

2003-10-06 Thread Jacob A. van Zanen

Hi, Try something like this: SELECT U1.User_Name , U2.User_Name , B.Booking_Date FROMUSER U1 , USER U2 , BOOKING B WHERE B.Booking_Creator = U1.User_ID AND B.Booked_User = U2.User_ID' Jack -Original

Re: [PHP-DB] Selecting two names from a table

2003-10-06 Thread Shaun

Thank you! Jacob A. Van Zanen [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 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