27,579
社区成员
发帖
与我相关
我的任务
分享
update
邮箱表
set
FromerCompanyID=客户ID,FromerCompanyName=CnName,FromerType=‘客户’
from
客户表
where
邮箱表.autoinc=客户表.autoinc
update
邮箱表
set
FromerCompanyID=供应商表ID,FromerCompanyName=CnName,FromerType=‘供应商’
from
供应商表
where
邮箱表.autoinc=供应商表.autoinc
update a set FromerCompanyID = b.autoinc,
FromerCompanyName = b.CnName,
FromerType = '客户'
from 邮箱表 a,客户表 b where a.Fromer = b.Email
update a set FromerCompanyID = b.autoinc,
FromerCompanyName = b.CnName,
FromerType = '供应商'
from 邮箱表 a,供应商表 b where a.Fromer = b.Email
update 邮箱表 set FromerCompanyID=客户ID,FromerCompanyName=CnName,FromerType=‘客户’
from 客户表 where 邮箱表.autoinc=客户表.autoinc
update 邮箱表 set FromerCompanyID=供应商表ID,FromerCompanyName=CnName,FromerType=‘供应商’
from 供应商表 where 邮箱表.autoinc=供应商表.autoinc
update a set FromerCompanyID = b.autoinc,
FromerCompanyName = b.CnName,
FromerType = '客户'
from 邮箱表 a,客户表 b where a.Fromer = b.Email
update a set FromerCompanyID = b.autoinc,
FromerCompanyName = b.CnName,
FromerType = '供应商
from 邮箱表 a,供应商表 b where a.Fromer = b.Email