Question

MariaDB not in issue

Forum|Forum|2 years ago
February 26, 2024
6 replies
0 views

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`);

stefanhelzle0001

Hard to say without knowing any details about your data.

tim.clarke

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)

N

nasirs4970

you can also try this:-
SELECT * FROM cases LEFT JOIN mail_poller ON cases.case_id = mail_poller.case_id WHERE mail_poller.case_id IS NULL;

R

rupaa0642Author

Thank you. resolved

N

nasirs4970

Fine! Please verify the answers to close this thread.

harshitb6843

For these types of problems, the fastest way to identify the error is to use chatGPT. Try it when you face a problem next time. It works really well for such cases.

Sign up

Login with SSO

Login to the community

Login with SSO