Dynamics AX Atlas View Query's

Finance and Operations/AX Developer Forum
1

[Atlas is a Add-IN in Excel that allows you to extract data from Dynamics AX database in a Excel spread sheet.]

For example, I have a view called Atlas_LedgerTrans:

  1. table 1: LedgerTrans
  2. table 2 : VendTrans

Is it possible to says that LEDGERTTRANS AS LEFT OUTER JOIN RELATION BETWEEN VENDTRANS ?

[a VIEW or a TABLE as to be use via the ATLAS Add-IN]

It seems that only INNER JOIN are permitted in the VIEWS, can we use LEFT OUTER JOIN ?

(I do the same query in SQL and we can use LEFT, RIGHT, INNER JOIN, whatever we want why not in AX)

Thanks in advance!

Carlos