收款方式对账,一个单子显示两行数据
问题:收款方式对账,一个单子显示两行数据
select count(*),idfrom dat_gtss_dtl where GiftTag=1
group by id having count(*)>1
ORDER BY id
解决:
select GiftTag,*from dat_gtss_dtl where id='01HC0000319'
update dat_gtss_dtl set GiftTag=0 where id='01HN0075585'
页:
[1]