Combination records 1

[manmaria]

I have a table with data

A, DATE
B, DATE
C,DATE

Here DATE is irrelavant but I added to show how the data might look like.

I want to see the data like
A,B
A,C
B,A
B,C
C,A
C,B

How do I do that?

TIA

 

[ESquared]

SELECT
   T1.Col,
   T2.Col
FROM
   Table T1
   CROSS JOIN Table T2

[COLOR=black #e0e0e0]For SQL and technical ideas, visit my blog, Squared Thoughts.

[sub]The best part about anything that has cheese is the cheese.[/sub][/color]