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

0 vote287 views1 answer
Copy table dbeaver
SQL
0 vote331 views1 answer
Date diff sql
SQL
1 vote367 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
15 votes372 views4 answers
Mysql export database command line
SQL
0 vote379 views2 answers
MySQL PARTITION BY month automatically
SQL
34 votes384 views5 answers
Oracle alter table add column
SQL
0 vote371 views1 answer
Sqlalchemy empty table
SQL
1 vote347 views1 answer
How to get mysql db size
SQL
0 vote337 views1 answer
Components/Fields of Internal Table
SQL
3 votes407 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL