mysql query to check atleast one row is true

Question

Hi,

 

Table 1: Query Result

workflow	complaint	status	is_onsite
1	1	Active	0
1	1	Cancel	1

 

Table 2: Expecting

Workflow	complaint	true
1	1	yes

 

in Table 1, if any one row having is_onsite =1 then i have to consider that particular complaint as true