SELECT bid FROM test1
where pid in (select fid from test2 m where m.date between sysdate-1 and sysdate) ---当天日期内的记录
GROUP BY bid ---去掉重复记录
SELECT bid FROM test1
where pid in (select fid from test2 m where m.date between sysdate-1 and sysdate) ---当天日期内的记录
GROUP BY bid ---去掉重复记录