Using a field as criteria

  • Thread starter Thread starter Val
  • Start date Start date
V

Val

Hi there,

I am tring to query a set of data but exclude any lines
that have the same information as another table.

Example:
Say I have a list of social security numbers of everyone
in my company and I am looking to leaveout anyone who's
social security number is ina a bad employee table how do
I get the query to have a negitive relationship or use
that field in the second table as criteria?
 
There is an Unmatched Query wizard that can give you this result.

Basically, you end up with an outer join (double-click the line joining the
2 tables in query design), where the related table's foreign key is null
(i.e. it doesn't match anything).
 
Back
Top