@NogDogJan 04.2023 — #Assuming I understand correctly what you want (not a given), I might try: [code=sql] select * from peopleTable p1 where not exists( select RowID from peopleTable p2 where p2.IDa = p1.IDb and p2.IDb = p2.IDa ); [/code] PS: [SQL Fiddle test](http://sqlfiddle.com/#!9/fdcd16/1/0)
reply?
×
Success!
Help @kiwis spread the word by sharing this article on Twitter...