Unmatched Query

[Beagle1927]

Hello all,

I have a question about using unmatched queries.

Say that I have two tables. Both have similar data like

House Owner Name
House color

Say in one table I have:
House Owner Name: Joe Smith
House color: Red

In the other table I have:

House Owner Name: Joe Smith
House color: Blue

House Owner Name: Joe Smith
House color: Green


I need to find all the records in table 2 that are not in table one or
have a different house color. I tried an unmatched bu that only
gives me choice to do the match on (ie. I can say find all House
owners are in table two but not in table 1)

Thanks

 

[pietlinden]

Hello all,

I have a question about using unmatched queries.

Say that I have two tables. Both have similar data like

House Owner Name
House color

Say in one table I have:
House Owner Name: Joe Smith
House color: Red

In the other table I have:

House Owner Name: Joe Smith
House color: Blue

House Owner Name: Joe Smith
House color: Green

I need to find all the records in table 2 that are not in table one or
have a different house color. I tried an unmatched bu that only
gives me choice to do the match on (ie. I can say find all House
owners are in table two but not in table 1)

Thanks

if you've never played with outer joins before, now is a good time to
start. If you want, use the Find Unmatched wizard as a start. You
can join the tables/queries in the QBE grid and then if you right-
click on the arrow connecting the two tables, you can specify the join
type and the fields that are involved. The easy way to fix this is to
drag the other related field in one table to the other table and then
specify the join type as LEFT or RIGHT... then you should be fine.