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 )
