SELECT (ITRN_HIS.SOURCE-ITRN_HIS.SOURCE_QUAL) AS Source,
LIST.TRNCODE
FROM
ITRN_HIS,LIST WHERE
ITRN_HIS.SOURCE-ITRN_HIS.SOURCE_QUAL = LIST.TRNCODE
初步看是你
2.
sSQL=sSQL & "LIST.TRNCODE, "多了逗号
LIST.TRNCODE
FROM
ITRN_HIS,LIST WHERE
ITRN_HIS.SOURCE-ITRN_HIS.SOURCE_QUAL = LIST.TRNCODE
初步看是你
2.
sSQL=sSQL & "LIST.TRNCODE, "多了逗号
你最好在写之前把完整的sql语句执行一下(比如gold32这样的工具比较好用),正确了,再往代码里面写。
sSQL="SELECT ITRN_HIS.SOURCE||'-'||ITRN_HIS.SOURCE_QUAL AS Source, "
2.
sSQL=sSQL & "LIST.TRNCODE "
3.
sSQL=sSQL & "FROM "
4.
sSQL=sSQL & "ITRN_HIS, "
5.
sSQL=sSQL & "LIST WHERE "
6.
sSQL=sSQL & "ITRN_HIS.SOURCE||'-'||ITRN_HIS.SOURCE_QUAL = LIST.TRNCODE "试试这样是否行