Not so tough query

[pdbowling]

Hey all.
I've got a query on two tables.

One is

TruckNumber...field.... field2.....
T001................xxx......xxx
T002................stuff....data
T010................xxx......xxx
T012................xxx......xxx
T015................xxx......xxx

the other

type........EQ9 <----EQ9 is truck number in this table
Tractor....T010
Tractor....T015


I'm trying to get the result

TruckNumber.......field1...field2
T001....................xxx......xxx
T002....................xxx......xxx
T012....................xxx......xxx
where the TruckNumbers in table 2 are sifted out of table 1.

I tried this query, but it keeps prompting me for table2.EQ9 which only lets me eliminate one truck number at a time.

SELECT table1.* FROM [table1] WHERE (((table1.TruckNumber)<>(Table2.EQ9)))

Where did I screw it up?

Thanks everyone.
PB

 

[Jon K]

SELECT DISTINCTROW Table1.TruckNumber, Table1.Field1, Table1.Field2
FROM Table1 LEFT JOIN Table2 ON Table1.TruckNumber = Table2.EQ9
WHERE (((Table2.EQ9) Is Null));

 

[pdbowling]

Super

Thank you guys. I knew left joins combined but the requery on 'null' was just barely outside my intuitive abilties. Superb
PB