how to wirte this script ,but it can run ok on sqlserver7 ,error at dbf
of bde
UPDATE LSKC SET
A2=3D(SELECT SPDM.A2 FROM SPDM WHERE A1=3DLSKC.A1),
A3=3D(SELECT SPDM.A4 FROM SPDM WHERE A1=3DLSKC.A1),
A4=3D(SELECT SPDM.A3 FROM SPDM WHERE A1=3DLSKC.A1),
A5=3D(SELECT SPDM.A5 FROM SPDM WHERE A1=3DLSKC.A1)
FROM LSKC,SPDM
WHERE LSKC.A1=3DSPDM.A1
DBF BDE =B1=A8=B4=ED=A3=BA=20
Invalid use of keyword=20
Token: FROM
