Do this:...

select * from Table1 a, Table1 b

where a.er_entity = b.er_target_id

That should give you the results you are looking for.