How to Insert data If Table1 <> Table2?

[BigBig5]

I am trying have text data insert if table1.lastname and table1.firstname <> table2.lastname and table1.firstname without having to do it manually. Is there a way to do it?

[June7]

Can try building a Find Unmatched query (there is a wizard for that) and use that as the source for an INSERT SELECT sql action.

[BigBig5]

Can try building a Find Unmatched query (there is a wizard for that) and use that as the source for an INSERT SELECT sql action.

I have an Unmatched query but don't know how to go with INSERT SELECT sql.

[June7]

Something like:

INSERT INTO tablename(fieldname1, fieldname2) SELECT fieldname1, fieldname2 FROM queryname;