Query for getting two records from different Tables

Dynamics 365 for Finance and Operations/AX Developer Forum
#1

I have to retrieve one record from sales table and one record from cust table,how should we write query for that??

#2

Use a join. But first decide with customer account number you want to use (either SalesTable.CustAccount or SalesTable.InvoiceAccount).