>>>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.
>>>>
>>
>>Sorry, I don't understand your Q...
>
>Maybe there're no records with positive NoSerial_Amt in the No_Serial table that are not in the StockNo_No table?
Nope
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site