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

1.1k

please help me

Answers (3)

Next Recommended Forum

Sql Means

How to prevent Sql Error : Must declare the scalar variable

Forum Statistics

Please welcome our newest member Abu Dhabi Visa.
3,083,139 users have contributed to 147,418 threads and 483,473
In the past 24 hours, we have 10 new threads, 21 new posts, and 130 new users.
In last week, the most popular thread is 'System.Data.SqlClient'.

Upcoming Events

View all

Excel Automation with Power Automate : Automate Your Business Processes - Ep.3
Global Azure Bootcamp - Rasipuram
Software Architecture Conference - 2025