Single query to fetch data from Sales Header and Sales Invoice Header tables

Hi All,

I am trying to write a single query that fetch data from both the tables "Sales Header" and "Sales Invoice Header". Can someone give me an example of how to write a union query in Business Central?

Is there any other option that it can be achieved?

Related
Recommended