Join queries

[peewan]

Hi all, I have 2 queries need to join together by ID.

Medical Query: list all member had medical
Vision Query: list all member had Vision coverage

I want to get All members who had Medical with no Vision. (If member had Medical and Vision, they still not count in)

How do I do the join?

Left join: 1:1, 0:n
Right join:0:n, 1:1
Full outer join: 0:n, 0:n

Thank you,

[MFGF]

Hi all, I have 2 queries need to join together by ID.

Medical Query: list all member had medical
Vision Query: list all member had Vision coverage

I want to get All members who had Medical with no Vision. (If member had Medical and Vision, they still not count in)

How do I do the join?

Left join: 1:1, 0:n
Right join:0:n, 1:1
Full outer join: 0:n, 0:n

Thank you,

One way to do this is as follows:

Create a left outer join to begin with [Medical Query ID] 1:1 <--> 0:1 [Vision Query ID]

Then on the resultant joined query you need to filter eg [one of the items from the Vision Query] is null

Cheers!

MF.

[peewan]

One way to do this is as follows:

Create a left outer join to begin with [Medical Query ID] 1:1 <--> 0:1 [Vision Query ID]

Then on the resultant joined query you need to filter eg [one of the items from the Vision Query] is null

Cheers!

MF.

Thank you :)