How query for Records in table 1, but not in table 2 ?

[buntnik]

I am a very much novice at Access. Please help.

Have two tables with data about servers from two sources.

Table1 has HOSTNAME, SERIAL, IP

Table2 has HOSTNAME, SERIAL, IP

I need
Hostnames that appear on Table1, but not on Table2.

I put the fields of Table1 in a query. In criteria in first column under HOSTNAME, I put
<>All (SELECT [HOSTNAME] FROM [Table2] WHERE [HOSTNAME] = HOSTNAME)

But get nothing. I think because I am joining on this field and/or because I am selecting for hostnames the same where I am looking for hostnames different, but when I take the where clause out, I get syntax error.