Displaying results from a comparison in query

[webmagic]

Hello,
I just figured out how to do a comparison and get only the results of those that are not equal, but I have several more fields that I need to include if the name fields from the table are the same. I have tried a few things and keep getting errors with syntax. Any help is appreciated.

Select Table1.name from Table1 LEFT JOIN Table2 ON (Table1.name = Table2.name)
WHERE (((Table2.name) is Null))
UNION Select Table2.name from Table1 RIGHT JOIN Table2 ON (Table1.name = Table2.name)
WHERE (((Table1.name) is Null));

 

[redneckgeek]

If you're only looking for those with a match, why not use an INNER JOIN?

SELECT TABLE1.FIELD1, TABLE2.FIELD2
FROM TABLE1 INNER JOIN TABLE2 ON TABLE1.FIELD1=TABLE2.FIELD1

 

[WayneRyan]

Web,

I just see mismatched parentheses:

Select Table1.name 
From Table1 LEFT JOIN Table2 ON 
       Table1.name = Table2.name
WHERE Table2.name is Null
UNION Select Table2.name 
from Table1 RIGHT JOIN Table2 ON 
      Table1.name = Table2.name
WHERE Table1.name is Null;

Wayne

 

[webmagic]

The code that I used above works. I only want the fields that do not match and it works for that. What I need is to include the other fields that are attached to those fields.

I am updating a table from orders that were processed from days before. I don't want to include the order numbers that are already in that table only the new ones. I hope this makes sense.

 

[MSAccessRookie]

Would the following code be what you want?

SELECT Table1.*
FROM Table1 LEFT JOIN Table2 ON Table1.FieldtoJoin = Table2.FieldtoJoin 
WHERE (((Table2.FieldtoJoin) Is Null));

I think this will give the new (complete) entries from Table1 and you can append them to Table2

 

[webmagic]

Thank you very much, got it working!

 

[WayneRyan]

Web,

I think you're talking to Pat ... she's good!

Wayne