Home Forums SQL Server 2005 SQL Server 2005 General Discussion How to Write Query for This RE: How to Write Query for This
michal.lisinski
SSCertifiable
Points: 6933
More actions
September 19, 2013 at 4:28 am
#1651430
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