LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mw9286

How can I join a reference table to 5 other tables and show where they match and leave it blank if the entry isn't found in the table. In the example below Value 1 from the reference table exist in tables 1,2 & 3 and not in 4 & 5.

REFERENCE TABLE TABLE 1 TABLE 2 TABLE 3 TABLE 4 TABLE 5
1 1 1 1
2 2 2 2 2 2
3 3
4 4 4 4 4
5 5 5 5 5 5


After this completes I want a report that only returns data if the entry's from the reference table isn't found in all 5 tables of the five tables. Only returns data related to reference values 1,3 & 4 since reference values 2 & 5 existed in all tables.

REFERENCE TABLE TABLE 1 TABLE 2 TABLE 3 TABLE 4 TABLE 5
1 1 1 1
3 3
4 4 4 4 4

Thank you,

Mike

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

Does the attached graph show what you are looking for?

I'm not sure I set up the inputs correctly, but it does produce the output you defined.
Attachments:
JoinReferenceTableToManyTables.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mw9286

Thank you. This solution worked perfectly.