Hi All aXperts,

How to write a query to find whether the purchID from purchtable is not in the vendpackingslip jour table? ie no items should be packed for the purch id in the purchtble? Plz Help…

A quick example :slight_smile:

PurchTable tPurchTable;
VendPackingSlipJour tVendPackingSlipJour;
while select tPurchTable
notexists join tVendPackingSlipJour
where tVendPackingSlipJour.PurchId == tPurchTable.PurchId

Thank you kyle…Hope this will work…:slight_smile: