SELECT * FROM CUST
INNER JOIN SYS_PRSNL_CLSF ON (cust.CUST_ID = sys_prsnl_clsf.PRSNL_ID)
LEFT OUTER JOIN SYS_PRSNL ON (cust.CUST_ID = sys_prsnl.PRSNL_ID)
where sys_prsnl.full_name ='"&sousuo&"'
...全文
545打赏收藏
SQL语句在sql分析器里面执行成功,转到asp里面怎么就不行了啊。
SELECT * FROM CUST INNER JOIN SYS_PRSNL_CLSF ON (cust.CUST_ID = sys_prsnl_clsf.PRSNL_ID) LEFT OUTER JOIN SYS_PRSNL ON (cust.CUST_ID = sys_prsnl.PRSNL_ID) where sys_prsnl.full_name ='"&sousuo&"'
SELECT * FROM CUST INNER JOIN SYS_PRSNL_CLSF ON (cust.CUST_ID=sys_prsnl_clsf.PRSNL_ID) LEFT OUTER JOIN SYS_PRSNL ON (cust.CUST_ID=sys_prsnl.PRSNL_ID) where sys_prsnl.full_name='"&sousuo&"'