Progress 9.1d query help

Posted by prabathsrp on 09-Nov-2006 21:39

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

All Replies

Posted by jtownsen on 10-Nov-2006 01:47

Assuming you're looking for an ABL query and not an SQL query, you could try something like this:


WHERE NOT CAN-FIND(FIRST Order WHERE Order.custnum = Customer.custnum)

Posted by prabathsrp on 10-Nov-2006 09:13

thank you very much jam. its working perfectly.

This thread is closed