Thank you for the suggestion Jean-Pierre.

I found another solution that gave me the intended results:

select tbl1.*

from table1 tbl1, table1 tbl2

where tbl1.inv_tag=tbl2.inv_tag

and tbl1.rm_id<>tbl2.rm_id

order by tbl1.inv_tag

Thanks again!