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

(0) Share

Report

Posted on by NoobDaxCoder

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 (1)

Answers (1)

Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

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

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