无法绑定由多个部分组成的标识符

pb2000 2009-02-22 12:35:07

本人用pb10 odbc接口联接sqlserver2005建立数据窗口，并设置检索参数psd_lsh，检索时出现“无法绑定由多个部分组成的标识符‘clpsd_mx.psd_lsh’”是什么原因，如何修改？

相关数据窗口语法如下：

SELECT clpsd_mx.tph,
clpsd_mx.gdh,
clpsd_mx.psd_lsh,
dm_cxfs_a.cxfs_mc,
dm_tzzl_a.tzzl_mc,
dm_tlmcph_a.tlmcph_mc,
dm_tlmcph_b.tlmcph_mc,
dm_tlmcph_c.tlmcph_mc,
fdtzgy.nbm_tzds,
dm_ys_a.ys_mc,
dm_ys_b.ys_mc,
dm_ys_c.ys_mc,
fdtzgy.nbm_gmh1,
fdtzgy.nbm_gmh2,
fdtzgy.nbm_gmh3,
dm_cxfs_b.cxfs_mc,
dm_tzzl_b.tzzl_mc,
dm_tlmcph_d.tlmcph_mc,
dm_tlmcph_e.tlmcph_mc,
dm_tlmcph_f.tlmcph_mc,
fdtzgy.wbm_tzds,
dm_ys_d.ys_mc,
dm_ys_e.ys_mc,
dm_ys_f.ys_mc,
fdtzgy.wbm_gmh1,
fdtzgy.wbm_gmh2,
fdtzgy.wbm_gmh3
FROM {oj fdtzgy LEFT OUTER JOIN dm_cxfs dm_cxfs_a ON fdtzgy.nbm_cxfs_dm = dm_cxfs_a.cxfs_dm LEFT OUTER JOIN dm_cxfs dm_cxfs_b ON fdtzgy.wbm_cxfs_dm = dm_cxfs_b.cxfs_dm LEFT OUTER JOIN dm_tzzl dm_tzzl_a ON fdtzgy.ntzzl_dm = dm_tzzl_a.tzzl_dm LEFT OUTER JOIN dm_tzzl dm_tzzl_b ON fdtzgy.wtzzl_dm = dm_tzzl_b.tzzl_dm LEFT OUTER JOIN dm_tlmcph dm_tlmcph_a ON fdtzgy.nbm_tlmcph1_dm = dm_tlmcph_a.tlmcph_dm LEFT OUTER JOIN dm_tlmcph dm_tlmcph_b ON fdtzgy.nbm_tlmcph2_dm = dm_tlmcph_b.tlmcph_dm LEFT OUTER JOIN dm_tlmcph dm_tlmcph_c ON fdtzgy.nbm_tlmcph3_dm = dm_tlmcph_c.tlmcph_dm LEFT OUTER JOIN dm_ys dm_ys_a ON fdtzgy.nbm_ys1_dm = dm_ys_a.ys_dm LEFT OUTER JOIN dm_ys dm_ys_b ON fdtzgy.nbm_ys2_dm = dm_ys_b.ys_dm LEFT OUTER JOIN dm_ys dm_ys_c ON fdtzgy.nbm_ys3_dm = dm_ys_c.ys_dm LEFT OUTER JOIN dm_tlmcph dm_tlmcph_d ON fdtzgy.wbm_tlmcph1_dm = dm_tlmcph_d.tlmcph_dm LEFT OUTER JOIN dm_tlmcph dm_tlmcph_e ON fdtzgy.wbm_tlmcph2_dm = dm_tlmcph_e.tlmcph_dm LEFT OUTER JOIN dm_tlmcph dm_tlmcph_f ON fdtzgy.wbm_tlmcph3_dm = dm_tlmcph_f.tlmcph_dm LEFT OUTER JOIN dm_ys dm_ys_d ON fdtzgy.wbm_ys1_dm = dm_ys_d.ys_dm LEFT OUTER JOIN dm_ys dm_ys_e ON fdtzgy.wbm_ys2_dm = dm_ys_e.ys_dm LEFT OUTER JOIN dm_ys dm_ys_f ON fdtzgy.wbm_ys3_dm = dm_ys_f.ys_dm},
clpsd_mx
WHERE ( clpsd_mx.fdtzgy_lsh = fdtzgy.lsh ) and
( (clpsd_mx.psd_lsh = :psd_lsh ) )
ORDER BY clpsd_mx.lsh ASC

...全文