>Why do you think that should be any record selected?
>
>>I'm having trouble getting the correct syntax for this:
>
SELECT NoSerial_No, [No Descrip] AS StockNo_Des ;
>> FROM No_Serial WHERE NoSerial_Amt > 0 AND ;
>> NoSerial_No NOT IN ;
>> (SELECT StockNo_No FROM StockNo)
>
>>Although I'm not getting errors, the result does not contain NoSerial_No records which do not exist in the StockNo table... in fact the result is an empty cursor.
>>
Thanks to you both - the problem was that there was a null StockNo_No value in the StockNo table. Filtering it out with a where clause fixed the problem.
Thanks to Joseph Bunker here in the office for pointing that out - in seconds.
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site