I would like to construct a complex SQL Query.

Image of the table:

![](https://i.stack.imgur.com/ZujIm.png)

First, I would like to select all entries WHERE column\_1 and column\_2 have similar id of each other and WHERE Column\_3 is equal to 1. 

Thus, it should only return ids: 10000001 and 10000002 and NOT ids: 10000003 and 10000004 because id 10000004 has 2 in column\_3 and therefore is not reciprocal of id 10000003.

Second, once ids 10000001 and 10000002 are selected from table\_1, I would like to retrieve data from table\_2.

Hence, I would like a query that helps me getting table\_2.column\_2 FROM ids in table\_1 WHERE table\_1.column\_1 AND table\_1.column\_2 have ids of each other AND table\_column\_3 is equal to 1.