ANY answer.
Re: How can I selet rows which have 2 columns values cross equal?
Solution was given by Bruno Wolf III:
Self join the table.
Something like (untested):
[sql]
SELECT t1.id, t1.a, t1.b
FROM test t1, test t2
WHERE
t1.a = t2.b
AND
t1.b = t2.a
ORDER BY t1.id;
[/sql]
|