Hi, I wanted to return the rows from cases table which are not in mail poller. But for somereason the following query is not giving me the expected result. Can someone help what mistake I am doing here.
SELECT * FROM `Cases` WHERE `fk_caseTypeRef_id` = 53 and case_id not in (SELECT fk_case_id FROM `MAIL_POLLER`);
Discussion posts and replies are publicly visible
Try this:
SELECT * FROM `Cases` c WHERE `fk_caseTypeRef_id` = 53 and not exists (select 'X' from `MAIL_POLLER` where fk_case_id = c.case_id)