vfp中使用连接查询，结果提示“子查询太多”
SELECT T_tdd.ksh as 考生号,;T_tdd.zkzh as 准考证号,;T_tdd.xm as 姓名,;T_tdd.sfzh as 身份证号,;T_tdd.pcdm as 批次代码,td_pcdm.pcmc as 批次,;T_tdd.kldm as 科类代码,td_kldm.klmc as 科类,;T_tdd.tdcj as 投档成绩,;T_tdd.lqzy as 录取专业,T_jhk.zymc as 专业名称,; T_tdd.xbdm as 性别代码,Td_xbdm.xbmc as 性别,;T_tdd.jtdz as 交通地址,;T_tdd.lxdh as 联系电话,;T_tdd.sjr as 收件人,;T_tdd.yzbm as 邮政编码,;T_tdd.kslbdm as 考生类别码,td_kslbdm.kslbmc as 考生类别,;T_tdd.csny as 出生年月,;&ywColumn as 语文成绩,;&sxColumn as 数学成绩,;&wyColumn as 外语成绩,;T_tdd.zzmmdm as 政治面貌码,td_zzmmdm.zzmmmc as 政治面貌,;T_tdd.mzdm as 民族代码,td_mzdm.mzmc as 民族,;T_tdd.kstz as 考生特征码,td_zcdm.zcmc as 特征名称,;T_tdd.zxmc as 中学名称,;T_tdd.dqdm as 地区代码, Td_dqdm.dqmc as 地区,;T_tdd.kstc as 考生特长,;T_tdd.ksjlhcf as 考生奖惩 ;FROM (t_tdd LEFT OUTER JOIN td_pcdm ON T_tdd.pcdm = Td_pcdm.pcdm ; LEFT OUTER JOIN td_kldm ON T_tdd.kldm = Td_kldm.kldm ; LEFT OUTER JOIN t_jhk ON T_tdd.lqzy = T_jhk.zydh and t_tdd.kldm=t_jhk.kldm ; LEFT OUTER JOIN td_xbdm ON T_tdd.xbdm = Td_xbdm.xbdm ; LEFT OUTER JOIN td_kslbdm ON T_tdd.kslbdm = Td_kslbdm.kslbdm ; LEFT OUTER JOIN td_zzmmdm ON T_tdd.zzmmdm = Td_zzmmdm.zzmmdm ; LEFT OUTER JOIN td_mzdm ON T_tdd.mzdm = Td_mzdm.mzdm ; LEFT OUTER JOIN td_zcdm ON T_tdd.kstz = Td_zcdm.zcdm ; LEFT OUTER JOIN td_dqdm ON T_tdd.dqdm = Td_dqdm.dqdm )
