web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Creating Query by join...

Microsoft Dynamics AX (Archived)

Creating Query by joining Three Different datasource with OR relationship

(0) Share

Report

Report

Posted on by Derik

110

Hi All,

I need to join three datasource with two different kind of range with OR relation.

For ex

Select * from A join B join C where (A.a = B.a)||(A.a = C.a)

I need to write this in Query in x++,please guide me

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

nmaenpaa 101,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

These articles might help you:

[View:https://community.dynamics.com/365/financeandoperations/b/daxmusings/archive/2011/10/13/query-object-datasource-linking]

[View:https://docs.microsoft.com/en-us/dynamicsax-2012/developer/using-expressions-in-query-ranges]

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#1

GL-01081504-0 1

#1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans