iponomarenko
New Member
Hi,
I'm a progress newbie, I would like to get all records from table1 where there are no corresponding records in table2. something like all customers who don't have any orders.
this is easy with a FOR EACH customer and a NOT CAN-FIND (FIRST order WHERE order.customerID EQ customer.customerID).
but I want to do this in a query (QUERY-PREPARE statement), and CAN-FIND is not allowed, the error message says I'm supposed to use joins instead, but I can't figure out how to do this.
Anyone can help ?
Thanks !
I'm a progress newbie, I would like to get all records from table1 where there are no corresponding records in table2. something like all customers who don't have any orders.
this is easy with a FOR EACH customer and a NOT CAN-FIND (FIRST order WHERE order.customerID EQ customer.customerID).
but I want to do this in a query (QUERY-PREPARE statement), and CAN-FIND is not allowed, the error message says I'm supposed to use joins instead, but I can't figure out how to do this.
Anyone can help ?
Thanks !