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

What help you wants can you explain your question in detail

Answers

case queries using multiple tables in sql

mohamed eliyas

712

please help me

Answers (3)

Next Recommended Forum

Sql Means

How to prevent Sql Error : Must declare the scalar variable