case queries using multiple tables in sql

thank u sir

+1

Hi mohamed,

try looks this code is very easy,

SELECT emailaddress

,MAX(CASE WHEN cast(siteid AS varchar(max))= '1' THEN 1 ELSE 0 END) AS site1

,MAX(CASE WHEN cast(siteid AS varchar(max))= '2' THEN 1 ELSE 0 END) AS site2

FROM Users u

JOIN Users_Sites us

ON u.user_id = us.user_id --No idea what your actual join criteria should be.

GROUP BY emailaddress

+1

What help you wants ,can you explain your question in detail

+1