Viewing post 1 (of 1 total)
SELECT * into #true
FROM table t
WHERE subectinterested = 'true'
SELECT * into #false
WHERE subectinterested = 'false'
SELECT t.customer, t.subject, f.subject
FROM #true t
INNER JOIN #false f
ON t.customer = f.customer
Would that work?
June 17, 2011 at 7:26 am
#1340403