以下是简单多源报表用到的查询SQL，报表过滤的条件都是xx_org_name， 报表最后显示的内容不全面，只显示了第一个sql的org_name的结果，如下： 1. select count(id) outNum,referral_org_name from chss_referral_out where status in ('03', '05') GROUP BY referral_org_name  2. select count(id) backNum, receive_org_name from chss_referral_back where status in ('03', '05') GROUP BY receive_org_name;  |
