I have a database which I run once a month.
It has a table called 'Alpha', I need to compare the data on the new Alpha to the old one, eg;
Old Alpha
1
2
3
4
5
6
7
8
9
New Alpha
2
4
6
8
13
15
16
17
I need to
a] Generate a list where the number value appears in both old and new table, this is easy!
2
4
6
8
b] Generate a list of values which appear in the old Alpha table only.
1
3
5
7
9
c]Generate a list which appear in the new Alpha table only.
13
15
16
17
Help!
It has a table called 'Alpha', I need to compare the data on the new Alpha to the old one, eg;
Old Alpha
1
2
3
4
5
6
7
8
9
New Alpha
2
4
6
8
13
15
16
17
I need to
a] Generate a list where the number value appears in both old and new table, this is easy!
2
4
6
8
b] Generate a list of values which appear in the old Alpha table only.
1
3
5
7
9
c]Generate a list which appear in the new Alpha table only.
13
15
16
17
Help!