|
I have table (tbstudent) with 3 fields (stname,stmarks,stroll) , then i have created another table(tbbooks) with 2 fields (stbook,stroll) now what i m doing is that i want the names of just the books from table 2 which have been issued to students with thee names not starting with say 'v' the query that i m running is
SELECT STROLL FROM TBBOOKS WHERE STROLL NOT IN (SELECT STROLL FROM TBSTUDENT WHERE STNAME NOT LIKE 'V%');
the query is running fine if all values are present or even if there a null value passed to the row(s)
but when i insert a row with a empty value present in the table it returns no answer.
|
[URGENT] Help with NULLs & EMPTY values
Feb 5 2011, 01:11 PM
