Left Outer join

[J V]

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.

 

[BruceGatterman]

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

 

[mra]

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