Retrieving data from same table where multiple columns match in multiple rows

Question

I have a table with data where in a situation one rows' id becomes another rows reference id. The table is as below.

I tried to retrieve data as below,

select * from table1 t where t.id = t.reference_id

but it returns empty table.

like this:- select * from table1 inner join table1 h on t.id = t.reference_id — shamila
– shamila, Commented Jan 29, 2018 at 6:14
Specify the expected result as well. Formatted text, please! (I.e. no images....) — jarlh
– jarlh, Commented Jan 29, 2018 at 7:51

sanatsathyan · Accepted Answer · 2018-01-29 06:12:52Z

3

Try a self join like :

select * from table1 t1
inner join table1 t2 on t1.id = t2.reference_id

answered Jan 29, 2018 at 6:12

sanatsathyan

1,79314 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1