我確定網羅沒有問題. 應為每個單個試圖都可以run. 如果把這個試圖改寫成這樣就可以: 只1和2兩個試圖就可以.三個就不可以了. SELECT a.term,a.dinner_name,a.dinner_num as work_dinner_num,a.cmp_allowance, b.dinner_num as not_work_dinner_num,b.cmp_allowance as un_cmp_allowance, b.dinner_fee as un_dinner_fee FROM DinnerSummary1 a,DinnerSummary2 b WHERE a.term = b.term AND a.dinner_name = b.dinner_name
如果把這個試圖改寫成這樣就可以: 只1和2兩個試圖就可以.三個就不可以了.
SELECT a.term,a.dinner_name,a.dinner_num as work_dinner_num,a.cmp_allowance,
b.dinner_num as not_work_dinner_num,b.cmp_allowance as un_cmp_allowance,
b.dinner_fee as un_dinner_fee
FROM DinnerSummary1 a,DinnerSummary2 b
WHERE a.term = b.term
AND a.dinner_name = b.dinner_name
ping ip
telnet ip 1433
试试!
還是麼有用.
救命阿!
是因為你view錯誤了,我也出現過這個錯誤,最後用trace才查出來
View中限制非常多,反正一不小心就中招了,要不你對照view的說明
看看有那些地方不對,我覺得可能是基礎View中的Group By,也可能
是因為你的基礎view的列名相同實在是太多了,所以你可能需要為你
的新總的view指定不同的名字,如把你的a.term,a.dinner_name改寫
成a.term as aaa,a.dinner_name as bbb試試