UPDATE cardinfo
SET customernumber = t.customernumber
FROM hyzl t, cardinfo s
WHERE (s.CustomerName = t.HY_name
) 目的是想当表cardinfo的字段CustomerName值等于表hyzl的字段HY_name值时 把表cardinfo中字段CustomerName值修改为表hyzl中字段 customernumber的值上面这写法感觉不对 麻烦高人指点下
SET customernumber = t.customernumber
FROM hyzl t, cardinfo s
WHERE (s.CustomerName = t.HY_name
) 目的是想当表cardinfo的字段CustomerName值等于表hyzl的字段HY_name值时 把表cardinfo中字段CustomerName值修改为表hyzl中字段 customernumber的值上面这写法感觉不对 麻烦高人指点下
SET
customernumber = t.customernumber
FROM
cardinfo s,
hyzl t
WHERE
s.CustomerName = t.HY_name
SET
customernumber = hyzl.customernumber
FROM
hyzl
WHERE
hyzl.HY_name = cardinfo.CustomerName
笔误?到底是customernumber 还是 CustomerName ??:)UPDATE s
SET customernumber = t.customernumber
FROM hyzl t, cardinfo s
WHERE (s.CustomerName = t.HY_name
)or UPDATE cardinfo
SET customernumber = hyzl.customernumber
FROM hyzl
WHERE cardinfo.CustomerName = hyzl.HY_name
set CustomerName =HY_name
from cardinfo a
join hyzl b on a.CustomerName =b.customernumber
from hyzl where hyzl.hy_name=CustomerName
select CardInfo.*,hyzl.* from cardinfo,hyzl where (HY_name=CustomerName and cardinfo.CustomerNumber!=hyzl.CustomerNumber)
from hyzl
where cardinfo.CustomerName=hyzl.HY_name
字段大小写不影响吧
-----------------
一般mssql 数据库 不区分大小写的
select CardInfo.*,hyzl.* from cardinfo,hyzl where (HY_name=CustomerName and cardinfo.CustomerNumber!=hyzl.CustomerNumber)
-----------------
你改个语句查:
select CardInfo.*,hyzl.* from cardinfo,hyzl where (HY_name=CustomerName and cardinfo.CustomerNumber<>hyzl.CustomerNumber) --基本上 不用这个的 !=
用上面的语句都运行了 报告也显示全部修改完 可用下面这句去查 却还查出200多条 怎么会事
select CardInfo.*,hyzl.* from cardinfo,hyzl where (HY_name=CustomerName and cardinfo.CustomerNumber!=hyzl.CustomerNumber)
===============================================不会吧?那就奇怪了!
这样写查询:
select cardinfo.CustomerNumber,hyzl.CustomerNumber
from cardinfo,hyzl where (HY_name=CustomerName and cardinfo.CustomerNumber <> hyzl.CustomerNumber)如果有数据,复制一部分贴出来看看!