Which ARE NOT Duplicates!?!?

I

Isaac Sanchez

I have two tables Materlist(ML) and Weeklylist(WL).
ML has all the people I am responsible to deliver to
and WL has all the people I will be delivering to that week.
How can I do a query that will tell me the names that
are NOT in table ML that are in table WL.
Basically the query will tell me who the NEW people
are in my route.

TIA

Isaac
 
J

Jerry Whittle

SELECT WL.*
FROM WL LEFT JOIN ML ON WL.names = ML.names
WHERE ML.names Is Null;

You need to put in the proper field names for the three "names" above.
 
G

Granny Spitz via AccessMonster.com

Isaac said:
Basically the query will tell me who the NEW people
are in my route.
Click to expand...

SELECT WL.FirstName, WL.LastName
FROM Weeklylist AS WL LEFT JOIN Masterlist AS ML ON WL.FirstName = ML.
FirstName AND WL.LastName = ML.LastName
WHERE ISNULL(ML.FirstName) AND ISNULL(ML.LastName);
 
I

Isaac Sanchez

Okay, I put this in a query, yes?!?!
what will tell me which names are not duplicates?
the query is specific for this right?
I am missing something on this one can you
explain a little more, PLEASE?!?!
 
K

Keri in Vermont

Have you triend the "Find Unmatched Query Wizard" it will walk you through
the process.
 
G

Granny Spitz via AccessMonster.com

Isaac said:
Okay, I put this in a query, yes?!?!
Click to expand...

Yes, use SQL view.
what will tell me which names are not duplicates?
Click to expand...

All rows will show *new people* on your route, names that occur on the weekly
list but not on the master list.
I am missing something on this one can you
explain a little more, PLEASE?!?!
Click to expand...

You gave us the names of your two tables, Weeklylist and Masterlist, but you
didn't give us the names of the columns, so I gave you an example that shows
columns for each person's first name (FirstName) and last name (LastName).
If your columns are named differently you'll have to replace them with your
names in the query before you run it.
 
I

Isaac Sanchez

Okay to that working but now another Issue!!
I set a criteria on one of the fields, and it works
but what is odd is that I have to answer the question
FOUR times before it will show me the query results.

Here is the SQL behind the query:
SELECT DeliverT.CONSULTANT, DeliverT.[SHIP ADDR], DeliverT.[SHIP CITY],
DeliverT.[SHIP STATE], DeliverT.[SHIP ZIP], DeliverT.[PHONE NO]
FROM DeliverT LEFT JOIN [MASTER LIST 10-11-06] ON DeliverT.CONSULTANT =
[MASTER LIST 10-11-06].[Customer Name]
WHERE ((([MASTER LIST 10-11-06].[Customer Name]) Is Null) AND
((DeliverT.WEEK)=[Week?]));

Isaac
 
Top