web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Exists Join involve t...

Microsoft Dynamics AX (Archived)

Exists Join involve three tables. Master Table, Sub Table of the master, SubSubTable of SubTable

(0) Share

Report

Report

Posted on by NoobDaxCoder

6

Scenario 1 doubt

Integer field. one to one relation from MainTable to SubTable to SubSubTable

MainTable = 1,2,3,4

SubTable = 1,2,3

SubSubTable = 1, 2,3

MainTable mainTable;
SubTable subTable;
SubSubTable subSubTable;

while select mainTable
notexists join subTable where subTable.IntegerSub == mainTable.Integer
notexists join subSubTable where subSubTable.IntegerSubSub == subTable.IntegerSub

Output

5633.Capture.JPG

How 4 in the result, eventhough, 4 does not exists in the three subtables?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

1) your child tables' subqueries looks like this:

1,2,3 notexists 1,2,3 = empty recordset.

2) parent table against subqueries:

1,2,3,4 notexists empty recordset = 1,2,3,4

I think what you meant is to link your second sub-table against the main datasource instead.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 39

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans