I have a question about using count in an Intersect Statement. I want to get the total count of the following SQL Statement: How would I do this? SELECT nvl((c.sr_num),0)), FROM s_evt_act a, s_srv_req c WHERE a.sra_sr_id = c.row_id and a.priv_flg = 'N' and a.x_cp_created between (sysdate-1) and sysdate intersect SELECT (nvl((b.sr_num),0)) FROM s_srv_req b WHERE b.x_cp_updated between (sysdate-1) and sysdate
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
