请问是SQL 语句哪里出错?
<%set rs=server.CreateObject("ADODB.Recordset")
sql="select cpxh_name_cht from MS_MainCatalog,MS_catalog,MS_products where MS_products.mctl_id = MS_MainCatalog.mctl_id and MS_products.ctl_id = MS_catalog.ctl_id " '我要后面这三个表的ID都相等的情况下输出 MS_products.cpxh_name_cht
rs.open sql,conn,1,1
while rs.eof
response.Write (rs("cpxh_name_cht"))
wend
rs.close
set rs=nothing
%>
[[it] 本帖最后由 huade 于 2008-8-4 16:23 编辑 [/it]]