Question about MS Query WHERE Clause

[shdawson]

Hi,


Have 2 worksheets in XLS. They have the same column, ID number. One worksheet has 8 ID numbers...the other has 10. Working on a query to trap the 2 ID numbers that are not in the first worksheet.

What would that syntax be, please?

ID Number list 1 <> ID Number list 2

???

Thanks,
S

 

[james_lankford]

let's say you had 2 tables listing the states in the united states

table State1 has more states in it than table State2 does

you want to find out which states are in State1, but not in State2

a left join is required with a test for null on the "lesser" table

SELECT 
  State1.ID, 
  State1.FullName, 
  State1.Population, 
  State2.ID
FROM 
  State1 
    LEFT JOIN 
      State2 
        ON State1.ID = State2.ID
WHERE 
(
  (
    State2.ID Is Null
  )
);

 

[shdawson]

LEFT join!!!

Thank you very much.

I will process and get back to you.


Kindly,
S