Looking for query suggestions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bonnie - 02 Apr 2008 16:21 GMT

I have two tables - master and export. I would like to only show the records
in export that are not in master. I want to do something like:

Show records where field1, field2 and field3 aren't the same in export as in
master.

Basically I am matching again three criteria.

I was trying to use the Unmatched wizard but it only uses 1 field.

Thanks,

Bonnie

Reply to this Message

John W. Vinson - 02 Apr 2008 18:31 GMT

>I have two tables - master and export. I would like to only show the records
>in export that are not in master. I want to do something like:
[quoted text clipped - 9 lines]
>
>Bonnie

You can apply the same logic as the unmatched query wizard using a
build-your-own query.

Create a Query joining export to master by all three fields.
Select EACH of the three join lines and change it to a left outer join - "show
all records in Export and matching records in Master".
Put a criterion on any one of the three fields in Master of

IS NULL

I'm assuming that all three fields have values in all three tables - if you're
trying to treat records with NULLS in both tables as a match it gets trickier.

Signature

John W. Vinson [MVP]

Reply to this Message

Bonnie - 02 Apr 2008 19:25 GMT

That's the ticket.

Thanks John, your a great help.

B

> >I have two tables - master and export. I would like to only show the records
> >in export that are not in master. I want to do something like:
[quoted text clipped - 22 lines]
> I'm assuming that all three fields have values in all three tables - if you're
> trying to treat records with NULLS in both tables as a match it gets trickier.

Reply to this Message