Try this:
select e.name, if(count(d.document_name)>0,'True','False') as flag from employee e left join document d on e.name = d.employee group by e.name;
Bert
Results 1 to 3 of 3
Thread: Need help with a queryThreaded View
Tags for this Thread |
|
|