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

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_

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

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 Mess