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

10y

779

1 Server Controls

please help me

case queries using multiple tables in sql

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)