I want to create a Query in AX 2012, I have tried a query on SQL, I want to implement SQL code to Query AX 2012.
I have a problem, when I have made the query, the data should appear 4 lines, but when in View in AX 2012 the data show 12 lines.
How I can create query like code SQL below ? Please advice
*Properties in Query AX 2012 (what i have to change ?)
the SQL query can be converted to AX query like this, please try with this.
select PurchId, ItemId from purchLine
where purchLine.PurchId == purchTable.PurchId && purchLine.PurchId == 'PO1700006006'
where purchLine.InventTransId == vendPackingslipTrans.InventTransId
where vendPackingslipTrans.PackingSlipId == vendPackingSlipJour.PackingSlipId
where vendPackingslipTrans.SourceDocumentLine == vendInvoicePackingSlipQuantityMatch.PackingSlipInvoiceSourceDocumentLine
where agitPobranchView.PurchId == purchLine.PurchId
where agitPobussinesunitView.PurchId == purchLine.PurchId
where agitPochanelView.PurchId == purchLine.PurchId;
Thanks, but I mean how to create Query on AX 2012 like SQL code I have.
This's Query from me, please, correct me if i wrong
I know, I just wanna "How to use Left Join to Query in AX ?" What should I use ? and what is the difference between options on below ? Can you advise
FetchMode : 1:1
Join Mode : Inner Join
Join Mode : Outer Join
If you want an outer join, use JoinMode = OuterJoin and not JoinMode = InnerJoin.