On Friday 10 March 2006 14:24, Fay Du wrote:
> Table test
> Id | a | b
> -----+----+---
> 1 | 100| 101
> 2 | 101| 100
> 3 | 100| 3
> 4 | 20 | 30
> 5 | 11 | 13
> 6 | 3 | 33
> 7 | 30 | 20
>
select a.*
from test a, test b
where a.a = b.b and a.b = b.a
order by id
Regards, Milorad Poluga
--
---------------------------------------
Milorad Poluga
HK CORES Beograd, Makenzijeva 31
[EMAIL PROTECTED]
---------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
