SQL Joins in C/AL ????

AliBomber
AliBomber Member Posts: 13
edited 2003-04-11 in Navision 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....

Comments

  • borsicsj
    borsicsj Member Posts: 32
    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....
    Brg,

    --
    János Borsics

Categories