List which has no reports submitted
Solution 1:
Using exists logic we can try:
SELECT s.site_name
FROM tbl_sites s
WHERE NOT EXISTS (SELECT 1 FROM tbl_reports r
WHERE r.site_id = s.site_id AND r.report_status = 2);
Using exists logic we can try:
SELECT s.site_name
FROM tbl_sites s
WHERE NOT EXISTS (SELECT 1 FROM tbl_reports r
WHERE r.site_id = s.site_id AND r.report_status = 2);