>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...