update a
set a.columnCode=b.code,a.columnName=b.title
from [fm_Content] a
Left Join [fm_Column] b on a.columnId=b.id
where a.columncode like '0004%'
set a.columnCode=b.code,a.columnName=b.title
from [fm_Content] a
Left Join [fm_Column] b on a.columnId=b.id
where a.columncode like '0004%'
Left Join [fm_Column] b on a.columnId=b.id
where a.columncode like '0004%'
set a.columnCode=b.code,a.columnName=b.title
where a.columncode like '0004%'
Left Join [fm_Column] b on a.columnId=b.id
set columnCode=b.code,columnName=b.title
from [fm_Content] a Left Join [fm_Column] b on a.columnId=b.id
where a.columncode like '0004%'