UPDATE LSKC SET
A2=(SELECT SPDM.A2 FROM SPDM WHERE A1=LSKC.A1),
A3=(SELECT SPDM.A4 FROM SPDM WHERE A1=LSKC.A1),
A4=(SELECT SPDM.A3 FROM SPDM WHERE A1=LSKC.A1),
A5=(SELECT SPDM.A5 FROM SPDM WHERE A1=LSKC.A1)
FROM LSKC,SPDM
WHERE LSKC.A1=SPDM.A1DBF BDE 报错:
Invalid use of keyword
Token: FROM
A2=(SELECT SPDM.A2 FROM SPDM WHERE A1=LSKC.A1),
A3=(SELECT SPDM.A4 FROM SPDM WHERE A1=LSKC.A1),
A4=(SELECT SPDM.A3 FROM SPDM WHERE A1=LSKC.A1),
A5=(SELECT SPDM.A5 FROM SPDM WHERE A1=LSKC.A1)
FROM LSKC,SPDM
WHERE LSKC.A1=SPDM.A1DBF BDE 报错:
Invalid use of keyword
Token: FROM
A2=(SELECT A.A2 FROM SPDM A,LSKC B WHERE A.A1=B.A1),
A3=(SELECT A.A3 FROM SPDM A,LSKC B WHERE A.A1=B.A1),
A4=(SELECT A.A4 FROM SPDM A,LSKC B WHERE A.A1=B.A1),
A5=(SELECT A.A5 FROM SPDM A,LSKC B WHERE A.A1=B.A1)
FROM LSKC,SPDM
WHERE LSKC.A1=SPDM.A1
LZ没想到应该先查一下DBF的SQL帮助吗我也很想找,但是去哪里找呢?to madyak(无天
2 DBF与SQL SERVER支持的SQL语句不一样,最好用SQL标准语法去写.SQL标准语法怎么写?to maming2003(嘿!兄弟!!要煤不???)
你的和我的没什么区别?因为字段不一样,实际上要A3对应A4的数值的。
我按照你的写法测试,错误依旧,但是要谢谢你。