web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) How to Create Query in AX

Microsoft Dynamics AX (Archived)

How to Create Query in AX

(0) Share

Report

Report

Posted on by Community Member

Hii Master,

I have a problem, when I join table with left join at SQL code with Query AX. but the results I receive differ between Sql and query AX.

How to use Left Join to Query in AX ? And What is the difference between options on below ?

Please advise

FetchMode : 1:1

Join Mode : Inner Join

FetchMode : 1:n

Join Mode : Inner Join

FetchMode : 1:1

Join Mode : Outer Join

FetchMode : 1:n

Join Mode : Outer Join

Thanks

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report

Hi,

Please refer the below link:

https://www.to-increase.com/ax-fetch-mode/

Thanks,

Kavitha.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Halo Cris,

I have a SQL code, can you suggest. How to implement in Queries in AX ?

Thanks

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#1

Martin Dráb 4 Most Valuable Professional

#3

Scott_itD 2 Community Manager

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans