Re: Problem related to not equal to function

2001-11-15 Thread Michael Brunson
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.nb

Problem related to not equal to function

2001-11-15 Thread Manish Mehta
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 presen