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 vote133 views1 answer
Download mysql database to excel in android studio
SQL
6 votes119 views1 answer
Rank function in oracle with example
SQL
0 vote124 views1 answer
Strat with in sql
SQL
0 vote125 views1 answer
Group_concat only returns one row
SQL
1 vote133 views1 answer
Top 10 rows in mysql
SQL
1 vote115 views1 answer
How to delete data from sql database in android
SQL
0 vote138 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote150 views1 answer
Modificar tipo de dato sql server
SQL
0 vote133 views1 answer
Where date major today mysql
SQL
3 votes142 views2 answers
Find string in stored procedure sql server
SQL