Newbie question about C/AL Table Query

NavDave · 2012-10-05

Hi,

I'm new the nav programming world.
I would like to know how do you do a inner join equivalent in C/AL.

For example I would like to retrieve result from nav tables following this Inner Query:

SELECT A.Col FROM A
INNER JOIN B ON A.Id=B.Id
INNER JOIN C ON B.Cid=C.Id
Where C.Id = 433

How do you translate this query in C/AL?
I know how to work with one record table but not multiple related tables.

Thanks

skulla · 2012-10-05

We do not have join statement in C/AL code but one way to accomplish this is to set filter in first table and while looping apply the join expression filter on second table and if match is found do your processing.

For ex:

A.RESET;
IF A.FINDSET THEN
REPEAT
B.RESET;
B.SETRANGE("No.",A."No.");
IF B.FINDFIRST THEN BEGIN
// do your processing
END;
UNTIL A.NEXT = 0;

Newbie question about C/AL Table Query

Comments

Categories