Simple Comparison Query

[Benjamin]

Hello,

Sorry I have to ask a very dum simple question but i tried
alot and still not have what I mean.
I've got two tables with both a colum that contains MAC-
adresses

Table1 (bla, bla, mac)
Table2 (bla, bla, mac)

If Table1.mac does not appear in Table2.mac then show it.

But how do I do that?

I have:

SELECT Table1.mac INTO Table3
FROM Table1, Table2
WHERE Table1.mac <> Table2.mac

But I still get a mac while it's mentioned in Table1 and 2.
Can anyone help me?

Thank you
Benjamin

 

[Allen Browne]

Use the Unmatched Query Wizard to get the query you want.

It will be an outer join, where Table2.mac is null.

 

[Benjamin]

Sorry but I don't get it

 

[Les]

Benjamin,

SELECT DISTINCTROW Table1.mac, Table1.bla
FROM Table1 LEFT JOIN Table2 ON Table1.mac = Table2.mac
WHERE (((Table2.mac) Is Null));