用于在行和列之间进行匹配的SQL查询

I have a table with a column called ID1 and a column called ID2. I want to collapse all rows where ID1 is ID2 in another row that also has ID1 as ID2. So basically this before the query is ran:I have a table with a column called ID1 and a c