Update mã CCDC cộng thêm mã đơn vị cơ sở

update ctdmcc set so_the_ts =  '0093' + rtrim(Ltrim(so_the_ts)) where so_the_ts in (select so_the_ts from dmcc where ma_dvcs = '0093')

update ctkhcc set so_the_ts =  '0093' + rtrim(Ltrim(so_the_ts)) where so_the_ts in (select so_the_ts from dmcc where ma_dvcs = '0093')
UPDATE dmcc set so_the_ts =  rtrim(ltrim(ma_dvcs))+ rtrim(Ltrim(so_the_ts)) where ma_dvcs = '0093'


SELECT * FROM DMCC order by ma_dvcs

SELECT * FROM DMCC where ma_dvcs = '0093    '