SELECT table.Col1, table.Col2
FROM table
UNION
SELECT table.Col2, table.Col1
FROM table
ORDER BY table.Col1;
Actually you might not even need the ORDER BY....
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-----Original Message-----
From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]
Hi SQL Developers,
I have a table as follows:
Col1 Col2
----------------
A B
C D
E F
G H
B A
E F
C D
H G
With a PK on (Col1, Col2).
How do I write a SQL script to get following result?
Col1 Col2
--------------------
A B
B A
C D
D C
E F
F E
G H
H G
Thanks for your help.
- Kirti