Hi,
I have a single table:
CREATE TABLE hotel (name char(50),room char(20));
name is unique.
but there can be one or more person assigned to any single room.
I would like to perform a query to determine:
who are living with 'BILL'?
currently, i tried using:
1. get the room where BILL is in.
2. then get who are in the same room as BILL.
is it possible to do it in one single query?
jaime
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php