sql语句的错误,帮忙检查一下
我要将三个表综合在一起查询,写的语句是这样的
E1="工程设计表 natural left outer join 工程项目表 "
E2="工程施工表 natural left outer join '"&E1&"' "
E3="工程施工表 natural left outer join (工程设计表 natural left outer join 工程项目表)"
sql="select * from '"&E2&"' "
sql=sql&"where"&gcbh_sql&town_sql&gcname_sql&tzbh_sql&tznr_sql&sjbgh_sql&sjry_sql&gczl_sql&gcl_sql&yjjsr_sql&sghtbh_sql&sgxkzh_sql&sgbh_sql&sgnr_sql&jfdb_sql&sgdw_sql&jlry_sql&sgy_sql&zfbabm_sql&zfbahgyf_sql&jzfysbm_sql&jssbh_sql&zbq_sql&jecx_sql&jedcx_sql&ztcx_sql&sjzcx_sql&sjdcx_sql
sql=replace(sql,"where and","where")
'添加排序功能
neirong=request("neirong")
fangshi=request("fangshi")
sql=sql&" order by "&neirong&fangshi
response.write sql