这句语句可以执行
sql="SELECT SK_customer.*, zhkz.*, zhkz.vest_mm FROM SK_customer INNER JOIN zhkz ON SK_customer.id = zhkz.id WHERE zhkz.vest_mm='174';"
换成所需要调用就不行了。请求帮忙修正。。。。
sql="SELECT SK_customer.*, zhkz.*, zhkz.vest_mm FROM SK_customer INNER JOIN zhkz ON SK_customer.id = zhkz.id WHERE zhkz.vest_mm="&session("sk_mclass")&";"

给我分

session（"sk_mclass"）是什么类型，数值还是字符
数值
sql="SELECT SK_customer.*, zhkz.*, zhkz.vest_mm FROM SK_customer INNER JOIN zhkz ON SK_customer.id = zhkz.id WHERE zhkz.vest_mm=”&session("sk_mclass")
字符
sql="SELECT SK_customer.*, zhkz.*, zhkz.vest_mm FROM SK_customer INNER JOIN zhkz ON SK_customer.id = zhkz.id WHERE zhkz.vest_mm='”&session("sk_mclass")&"'“