如題，用的mysql數據庫，sql語句：
SELECT s.id as id,s.true_name as true_name,(select dept_name from `sns`.sy_dept where id=document_number) as date_birth FROM `sns`.sy_users s?WHERE ( document_number in ( ? , ? , ? ) )
13 回答
冉冉說
TA貢獻1877條經驗 獲得超1個贊
@流沙°: 就覺得你這個語句寫的很奇怪，最后有一個document_number in，然后這里又有個 where id=document_number，干嘛不直接把兩個表inner join起來查？？
HUWWW
TA貢獻1874條經驗 獲得超12個贊
@流沙°: 用你寫的那個sql語句報這個錯：
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ( document_number in
(
'050748fe7fa' at line 6
]
添加回答
舉報
0/150
提交
取消