Unmatched qry, 2 fields
- From: "CP" <CP@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 26 Apr 2005 07:02:04 -0700
Hi:
I have 2 tbls named All HRMS and LOV_tbl. I'm trying to create an unmatched
qry. In each table there are 2 fields I'm comparing. The 2 fields in the
All HRMS are DIRECTORY and LOOKUP_CODE and in the LOV_tbl they are HR Access
directory and Oracle_Lookup_Code. The query should pull where the DIRECTORY
and HR Access directory equal and where LOOKUP_CODE and Oracle_Lookup_Code do
not equal. I can't seem to get it to work using the unmatched wizard.
.
- Follow-Ups:
- Re: Unmatched qry, 2 fields
- From: Michel Walsh
- Re: Unmatched qry, 2 fields
- Prev by Date: Re: No. of Open cases per day per agent
- Next by Date: RE: SQL Query...HELP REQUIRED!
- Previous by thread: Wildcard in IFF Expression
- Next by thread: Re: Unmatched qry, 2 fields
- Index(es):