SQL Joins in C/AL ????

AliBomber

---

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....

borsicsj

Hi,

if you'd like to use the joined fields mor than once you can create flowfields. Any join operator haven't been implemented yet (
But you mentioned report. As a report can contain several DataItems, you can joun them via the DataItemLink property. E.g.:

Data Item DataItemLinkReference DataItemLink
Sales Header
Sales Line Sales Invoice Header Document No.=FIELD(No.)

AliBomber wrote:

---

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....