You can just change the last part to have a subquery (I will use in so you can have multiple values in the WHERE clause) SELECT a.CLIENTID, a.CLIENTNAME, a.CREATEDATE, b.AREACODE, b.PHONENUMBER FROM CLIENT a INNER JOIN PHONE b ON a.CLIENTID = b.CLIENTID WHERE b.AREACODE IN /* You can put your query inside the ()s */ … Read more
Try to use or operator like this: select * from t1 join t2 on t1.id = t2.id and ((t1.ROE = 1 and t2.Currency1 = t2.Currency2) or(t1.ROE <> 1 and t1.ROE = t2.ROE)) solved Using a case statement in data validation
I think you are missing some logic operator between those two conditions. eg.: cursor = db.rawQuery(“SELECT * FROM videoplayer where ” + KEY_TAG_ONE + ” like ‘%”+ searchText +”%’ OR ” + KEY_TAG_TWO + ” like ‘%”+ searchText +”%'”, null); Which should select records where KEY_TAG_ONE or KEY_TAG_TWO contains searchText solved Like query for multiple … Read more
Something like this? $query .= “WHERE 1=1 AND e.id=p.employee_id AND p.office_id=o.id AND (o.office_name=””.mysqli_real_escape_string($officeName).”” OR o.office_name=””.mysqli_real_escape_string($firstName).”” OR o.office_name=””.mysqli_real_escape_string($lastName).””) “; I used mysqli_real_escape_string() here as an example, you should use the correct and necessary precautions to avoid SQL injection in your system. 5 solved Build dynamic WHERE clause in mySQL