I have two tables. version is 9.1d.
customer , order . One customer can place many orders.
in customer table we have customer A,B, C ,D, etc.
in Order table we have A's orders and C's orders
what is the query for selecting customers with out place orders. ex- B and D
Assuming you're looking for an ABL query and not an SQL query, you could try something like this:
FOR EACH Customer NO-LOCK
WHERE NOT CAN-FIND(FIRST Order WHERE Order.custnum = Customer.custnum)
thank you very much jam. its working perfectly.