-----------查询 当前团购人员 7天内的 有没报价 select gpr.pro_id,g.g_id,gi.item_id,gp.pri_id, gp.date,gp.j_price into #temp from dbo.groupbuy_item as gi left join dbo.groupbuy_price as gp on gp.item_id=gi.item_id left join dbo.groupbuy as g on g.g_id=gi.g_id left join dbo.groupbuy_product as gpr on gpr.pro_id=g.pro_id where man_id=30 and j_price is not null select count(*) from #temp t where not exists (select 1 from #temp where item_id = t.item_id and date > t.date) and dateadd(day,7,date)<getdate() drop table #temp