Saafia NM

Saafia NM

  • NA
  • 22
  • 7.8k

mysql query to check atleast one row is true

Dec 11 2017 2:53 AM
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

Answers (2)