Left Join possible with WebFocus?

[kaeserea]

Hi!

Is it possible to make something like a left join with the WebFocus language or do I have to do this with SQL?

(I know it works with SQL and that SQL can be embedded in Webfocus. But I am interested in whether it is also possible with WebFocus language elements.)

regards
Eva

 

[webphantom]

Eva,

add the following Set command before your Table request to do a Left Outer Join:

SET ALL=ON

 

[kaeserea]

Hi WebPhantom,

and after that? Can I do the JOIN statement as usual? Like JOIN FIELD1 IN DATA1 TO ALL FIELD2 IN DATA2

Eva