On Fri, 16 Nov 2001 10:41:31 +0530, Manish Mehta used a few recycled electrons to form: | Hello , | | I have a problem related to not <> or != (not equal to function) . | | The SQL Query is | | select a.cBook_Name from tbl_bookmaster as a , tbl_empbookrelation as b | where a.nbook_id != b.nbook_id | | It shows me wrong result. It shows me those rows also which are already | present in other table.
You should use a left join, instead. SELECT a.cBook_Name FROM tbl_bookmaster a LEFT JOIN tbl_empbookrelation b ON a.nbook_id = b.nbook_id WHERE b.nbook_id IS NULL This is guessing that you want the records that are in tbl_bookmaster, but not in tbl_empbookrelation. HTH, Michael --------------------------------------------------------------------- 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
