Left Outer join

J V

New Member
Can any one tell me please, whether we can use left outer join in for each statement. I tried to use it, and it gave me error message saying: "Join may be used only in open query".

Thanks a lot.
 
What does your code look like? You can achieve a left outer join by using nested FOR EACH blocks, as in the following example:

forCustomer:
FOR EACH customer:
display custnum name.
forOrder:
FOR EACH order WHERE order.custnum = customer.custnum:
display ordernum orderdate.
END. /* forOrder */
END. /* forCustomer */

Regards,
Bruce
 
Hi JV!

You can only use outer joins in open query, not for each. You have to use nested for each as Bruce said.


Regards
Mike
 
Back
Top