工作中用到的....

 

select * from sis_quota where mr_no='H70085'

select * from sis_styles_b where mr_no='H70085'


select  count(sis_styles_id),sis_id,mr_no,article,cust_article_no,mu_no,colour,total_qty,ship_date
 from sis_styles_b  group by sis_id,mr_no,article,cust_article_no,mu_no,colour,total_qty,ship_date having count(sis_styles_id)>1


select  count(quota_id),team_id,mr_no,article,cust_article_no,mu_no,colour,total_qty,ship_date,quota_qty,half_finished
 from sis_quota group by team_id,mr_no,article,cust_article_no,mu_no,colour,total_qty,ship_date,quota_qty,half_finished having count(quota_id)>1