小弟不才,oracle上手時間也不太長,今天在執行一句3個表串聯的查詢SQL語句時候報出了以上的錯誤提示,再三檢查語句,發現,如果加具體查詢條件的話,不報錯,不加就報錯,請教下各位大蝦,會是DataBase本身設置的問題嗎?
SQL:SELECT *
FROM wi_study_content_his a, user_base c, dept_info g
WHERE a.user_no = c.user_no
AND c.user_dept_no = g.dept_no
--AND a.user_no IN ('00028999')無錯誤SQL:SELECT *
FROM wi_study_content_his a, user_base c, dept_info g
WHERE a.user_no = c.user_no
AND c.user_dept_no = g.dept_no
AND a.user_no IN ('00028999')
為了大家便于看,我把具體欄位用*號表示
SQL:SELECT *
FROM wi_study_content_his a, user_base c, dept_info g
WHERE a.user_no = c.user_no
AND c.user_dept_no = g.dept_no
--AND a.user_no IN ('00028999')無錯誤SQL:SELECT *
FROM wi_study_content_his a, user_base c, dept_info g
WHERE a.user_no = c.user_no
AND c.user_dept_no = g.dept_no
AND a.user_no IN ('00028999')
為了大家便于看,我把具體欄位用*號表示
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货