select sum(cnt) from (SELECT COUNT(sli.sid) cnt FROM data_file df LEFT JOIN sales_line_item sli ON sli.data_file_sid = df.sid and sli.customer_sid=df.customer_sid and sli.DELETED = 1 AND sli.RESUBMITTED = 0 WHERE df.SID = :sid and df.customer_sid = :customerSid group by df.sid union all SELECT COUNT(sli.sid) cnt FROM data_file df LEFT JOIN inv_line_item sli ON sli.data_file_sid = df.sid and sli.customer_sid=df.customer_sid and sli.DELETED = 1 AND sli.RESUBMITTED = 0 WHERE df.SID = :sid and df.customer_sid = :customerSid group by df.sid) ;