第一次用access做数据库,郁闷致死,一句sql语句,老是说丢失操作符号,请各位大虾帮忙修正一下,急用,在线等!!!!UPDATE main
SET t.ClientName = s.ClientName
FROM main t, ClientNameAndTaxCode s
WHERE t.ClientTaxCode = s.ClientTaxCode
SET t.ClientName = s.ClientName
FROM main t, ClientNameAndTaxCode s
WHERE t.ClientTaxCode = s.ClientTaxCode
SET t.ClientName = s.ClientName
FROM main t, ClientNameAndTaxCode s
WHERE t.ClientTaxCode = s.ClientTaxCode
难道是我有rpwt?
UPDATE t
SET t.ClientName = s.ClientName
FROM [main] t, ClientNameAndTaxCode s
WHERE t.ClientTaxCode = s.ClientTaxCode
居然还是语法错误,我昏倒!
UPDATE t
SET t.ClientName = s.ClientName
FROM t s, ClientNameAndTaxCode s
WHERE t.ClientTaxCode = s.ClientTaxCode
郁闷啊,access
我按照你的改,还是一样的错误
FROM附近
UPDATE t
SET t.ClientName = s.ClientName
FROM [main] as t, ClientNameAndTaxCode as s
WHERE t.ClientTaxCode = s.ClientTaxCode
我哭了
UPDATE [main]
SET [main].ClientName = ClientNameAndTaxCode.ClientName
FROM [main], ClientNameAndTaxCode
WHERE [main].ClientTaxCode = ClientNameAndTaxCode.ClientTaxCode
SET t.ClientName = s.ClientName
from main as t inner join ClientNameAndTaxCode as s
on t.ClientTaxCode = s.ClientTaxCode
其他该法都是类似的错误,明明有from的阿
main可能是access的保留字也说不定。
SET t.ClientName = s.ClientName
WHERE t.ClientTaxCode = s.ClientTaxCode印象中JET的UPDATE 不与 FROM 同时用的,好久不用了,不知说得对不对.
SET main.ClientName = ClientNameAndTaxCode.ClientName
WHERE main.ClientTaxCode = ClientNameAndTaxCode.ClientTaxCodeUpdate 语句怎么可以包含 Form 子句?除非它在子查询中。
SET main.ClientName = ClientNameAndTaxCode.ClientName
WHERE main.ClientTaxCode = ClientNameAndTaxCode.ClientTaxCode上贴用了中文逗号,更正