select distinct jianli.*, jianlitoufang.jianliID,jianlitoufang.yonghuID from jianli,jianlitoufang where jianlitoufang.jianlitoufangID='" + num + "' and jianli.jianliID = jianlitoufang.jianliID and userName in(select userName from yonghu where yonghu.yonghuID=jianlitoufang.yonghuID
uj5u.com熱心網友回復：
SELECT DISTINCT jianli.*,
jianlitoufang.jianliID,
jianlitoufang.yonghuID
FROM jianli,
jianlitoufang
WHERE jianlitoufang.jianlitoufangID = '" + num + "'
AND jianli.jianliID = jianlitoufang.jianliID
AND userName IN (SELECT userName
FROM yonghu
WHERE yonghu.yonghuID = jianlitoufang.yonghuID)
你的sql有點亂， 幫你整理了一下。
把兩個表的表結構截個圖看下？
uj5u.com熱心網友回復：
感覺jianlitoufang.jianlitoufangID = '" + num + "'有問題uj5u.com熱心網友回復：
一般都是中文空格的問題轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/66389.html
標籤：疑難問題
上一篇：mysql安裝錯誤