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 
PurchTable tPurchTable;
VendPackingSlipJour tVendPackingSlipJour;
;
while select tPurchTable
notexists join tVendPackingSlipJour
where tVendPackingSlipJour.PurchId == tPurchTable.PurchId
{
info(strfmt("%1",tPurchTable.PurchId));
}
Thank you kyle…Hope this will work…