原代码:$sql_tar = "SELECT ap.*,dp.* from ach_target dp,ach_project ap where dp.DEPT_ID='$DEPT_ID' and (dp.TAR_PRO_ID=ap.PRO_ID or ap.PRO_MERGE=dp.TAR_PRO_ID) and dp.TAR_PRO_YEAR='$TAR_PRO_YEAR' and dp.TAR_PRO_MOUTH='$TAR_PRO_MOUTH' and ap.DW_SIGNS like '$DW_SIGNS%' group by ap.PRO_ID order by ap.PRO_SORT asc";
当表ach_target、ach_project联合查询时,因为“ap.PRO_MERGE=dp.TAR_PRO_ID”的存在,使得结果集获取了大量重复记录,则可以用group by 的方式,将相同的记录清理。