sql - select data where two column have the same data in two different tables

Question

I have two tables, and they have three column in common as shown below:

table 1

x	id2	id3
1	0	1
2	0	1
3	1	0

question from:https://stackoverflow.com/questions/66045414/select-data-where-two-column-have-the-same-data-in-two-different-tables

Answer 1

It is simple join

select t1.*
  from t1 join t2 on t1.id2 = t2.id2 and t1.id3 = t2.id3