語法如下: SELECT a.empno, a.empna, a.taxtp, b.code_ty from accod,stock where yer = :p_yer and corpno = :p_corpno and a.empno = b.empno group by a.empno,a.empna,a.taxtp,b.code_ty order by a.taxtp,a.empno 因為上面的語法只抓出stock 的資料(stock裡面的資料只是accod的一部份) 如果想依照accod把accod裡面的資料全抓出來,請問要如下語法？

看起來對應的應是empno，若是那試試看下面的語法... 不過yer 及corpno是要accod的才行 SELECT a.empno, a.empna, a.taxtp, b.code_ty from accod left join stock b on a.empno = b.empno where yer = :p_yer and corpno = :p_corpno group by a.empno,a.empna,a.taxtp,b.code_ty order by a.taxtp,a.empno

------
熊的學習 http://huwk.blogspot.com