Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Help in creating a query

    SELECT * into #true

    FROM table t

    WHERE subectinterested = 'true'

    SELECT * into #false

    FROM table t

    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?

Viewing post 1 (of 1 total)