SQL server query column yes or no

SELECT  a.ID, a.FirstName, a.Lastname,
        CASE WHEN COUNT(b.CustID) > 0 THEN 'YES' ELSE 'NO' END AS HasOrders
FROM    Customer a
        LEFT JOIN Orders b
            ON a.ID = b.CustID        -- <<== the linking column on both tables
GROUP   BY a.ID, a.FirstName, a.Lastname

Similar codes

34 votes129 views5 answers
Oracle alter table add column
SQL
1 vote125 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote148 views1 answer
Sql server roles and users
SQL
4 votes141 views3 answers
Sqlite show columns
SQL
0 vote139 views1 answer
Update and keep original value sql
SQL
0 vote125 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
0 vote134 views1 answer
View t-sql mail configuration
SQL
8 votes146 views1 answer
Check mysql version phpmyadmin
SQL
4 votes139 views2 answers
Oracle last day of month
SQL
0 vote127 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL