Reputation: 99
I have 2 tables with data like this: Table 1:
Table 2:
I would like to compare the values of both tables and return them when they match. In the example the returned rows would be order 1(personX is same as personX) and order 7(person Z is same as personZ).
How to do this?
I hope you guys can help me out!
Thanks :)
Upvotes: 0
Views: 43
Reputation: 40204
If you do an intersection of the two tables,
INTERSECT(CreatedTable, VerifiedTable)
you'll get this table:
Order Created By
1 PersonX
7 PersonZ
Upvotes: 1