How to realize JOINS in Attain

Hi, I have the following problem: I woould like to realize a Join from SQL in C/AL. So I need an Outer Join and also some usual Joins, but I don’t know If there exists an easy way to realize that in C/AL. Could anyone help me, maybe there are some equivalent operations in C/AL . Thank you very much for help…