I'd suggest you pick up an SQL book or do some more reading if you
don't
understand that.
--
---John Holmes...
John,
Do you have a good book recommendation for MySQL.. I'm looking for more
knowledge on improving my queries, etc. LEFT JOINS were completely
unfamiliar (still are) until you
Manohar [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] how to get records from one table that are not in
another table
Date: Sun, 27 Jul 2003 09:44:04 -0400
Smita Manohar wrote:
can anyone pls help me out to make the query like.. if two tables have
some comman records then how to find
heyy...
i put second condition (after AND) in the wrong place.. it should be after
LEFT JOIN ON
not after WHERE... following is the correct query...
SELECT A.room_type_id, room_type_desc FROM room_type_m A LEFT JOIN
hotel_room_type_d B ON A.room_type_id = B.room_type_id AND B.hotel_id =
