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

6 votes278 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote269 views2 answers
Mysql regexp match word
SQL
2 votes274 views3 answers
Oracle show column of table
SQL
0 vote266 views1 answer
Assign value to var in SQL
SQL
3 votes274 views4 answers
Stop MySQL
SQL
3 votes269 views2 answers
Sql random integer
SQL
0 vote267 views1 answer
Oracle sql winter time change
SQL
0 vote292 views1 answer
Is not numeric sql
SQL
0 vote285 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
1 vote292 views2 answers
Mysql update LAST_INSERT_ID()
SQL