[Solved] sql server 2008 select same field with different values [closed]

by


Maybe this works for you

SELECT
    y1.pid
    ,y1.description
    ,y2.description
FROM
    ytest AS y1
INNER JOIN
    ytest AS y2
ON
    y1.pid = y2.pid
AND y1.description = 'Log'
AND y2.description like 'Design%'

4

solved sql server 2008 select same field with different values [closed]