nick bijmoer
nick bijmoer

Reputation: 99

compare values of different table columns and return when they match

I have 2 tables with data like this: Table 1:

enter image description here

Table 2:

enter image description here

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

Answers (1)

Alexis Olson
Alexis Olson

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

Related Questions