业务逻辑讲, 报价编号和产品编号scheduleindex 一对一, 系统出现问题出现不是1:1情况, 查出来:
select distinct pm.BookingNote, count( distinct pm.ScheduleIndex)
from
pricemain pm, priceport pp
where pm.priceid = pp.priceid
and pm.MakingDate>='2017-01-01'
group by pm.BookingNote
having count( distinct pm.ScheduleIndex)>1
order by pm.BookingNote