Can someone please tell me what's wrong with my code?
(select count(ca.is_applicable) from checklist_answers ca, checklist_items ci where ca.checklist_item_fk = ci.checklist_item_pk and ca.is_applicable = 0 and ci.is_mandatory = 1) > 0;
I want a true of false value, true if there is an entry where is applicable is 0 and is mandatory is 1 (from different tables, but thats not the problem). This would return true because it would then be greater than 0 as I put at the end. However, I get that annoying "Encountered the symbol SELECT when expecting one of the following ...." Which seems to come up half the time I start with Select. I get that the APEX developers don't allow that, but at least make it consistent because half of my expressions start the exact same way and sometimes I get this error message and other times I do not. Please let me know that is wrong and why there is an inconsistency.
Thanks,
Matthew