Multiple Counts Issue

[teradatasql]

Hi,

I have a table with columns
colA colB
x x
x y
x z
y x
y y
y z
z x
z y
z z

I want to link values in colA with colB just once. My result should have something like this
x x
x y
x z
Can someone please help me with this.

Thanks!

 

[bkclaw113]

You have hopefully figured this out by now, but if not....try this
[tt]Select
colA
, colB
From
(
Select
colA
From
myTable
Group By
colA
) A
Inner Join
(
Select
colB
From
myTable
Group By
colB
) B
On
colA = colB
[/tt]