Small and medium business | Business Central, N...

Sql Union in AL?

(0) Share

Report

Posted on by RomRyan

Hi all,

I have this query. How can I achieve this in AL? . I don't want join, I want union. I need to use this in making a report and also in using the whole set of data to do some other validations.

SELECT ‘17’ As [Table No],[G_L Account No_],[Document No_],Amount
FROM [Company$G_L Entry]
UNION
SELECT ‘81’ As [Table No],[Account No_],[Document No_],[Amount (LCY)]
FROM [Company$Gen_ Journal Line]

Regards,

RomRyan

Categories:

Business Central

All responses (2)

Answers (0)

Samantha73 2,437 on at

Like (0)

Report

Sql Union in AL?

A union in AL can be achieved via a temp table, but be aware that the performance could be compromised. Another alternative is to provide a PBI solution if this is only for reporting.
Suggested answer

Hein Kruger 501 on at

Like (0)

Report

Sql Union in AL?

Hi you can look into Flowfields.
Use the flowfield type lookup.
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-flowfields