Simple Comparison Query

  • Thread starter Thread starter Benjamin
  • Start date Start date
B

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
 
Use the Unmatched Query Wizard to get the query you want.

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

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