Hi

I'm not sure what you are looking for, but try this:

SELECT t1.Col1,t2.Col2

FROM SomeTable As t1 CROSS JOIN

SomeTable AS t2

WHERE (t1.Colx = 'Your_condition') AND (t2.Coly = 'Your_next_condition')

Br.

Mike