Updating Tables

[RichardMGreen]

Hi all

Bit of an oddity here (for me at least).
I've got some table which are used as master lists for group items. E.g.

Item 1 Group 1
Item 2 Group 1
Item 3 Group 2
Item 4 Group 2
Item 5 Group 3
Item 6 Group 3

and so on.

I've also got some tables where data is imported automatically.

What I want to do is check the imported tables for items that are not in the master tables (e.g. Item 7), flag it up somehow, add it to the master list and let the user know it needs adding to a group.

That gives me two questions:-
1) Is it possible?
2) If it is, where would I start?

All help greatly appreciated.

 

[Dartagnan]

Not sure I understand exactly what you are looking for, but this always helped me find records that do not match.

SELECT
ID
FROM
Table1
LEFT JOIN
Table2
ON Table1.ID = Table2.ID
WHERE
Table2.ID IS NULL

UNION

SELECT
Table2.ID
FROM
Table2
LEFT JOIN
Table1
ON Table2.ID = Table1.ID
WHERE
Table1.ID IS NULL

 

[RichardMGreen]

Thanks for that. I'll have a look and see how I get on.