SQL 中的right join 在DB2/400中能用吗

xihii

在DB2/400交互SQL中使用 right join却说right无效,right join 在DB2/400中能用吗

fzrxh

我测试了，可以的

> select *                        
   from pc01 right join pc09      
   on pc01.porno=pc09.porno        
   SELECT statement run complete.

xihii

但运行后是 "Token RIGHT was not valid. Valid tokens: FOR WITH ORDER UNION OPTIMI ",什么原因?

fzrxh

把你完整语句以及运行后提示贴出啦，有图最好拉

顺便说下我运行主机为v5r3，怀疑是否你的版本较低

xihii

select *                                                            
from test02 a right outer join test01 b                     
on (a.id_no=b.id_no)                                             
Token RIGHT was not valid. Valid tokens: FOR WITH ORDER UNION OPTIMI
版本:v4r3

xihii

select *                                                            
from test02 a right join test01 b                     
on (a.id_no=b.id_no)                                             
Token RIGHT was not valid. Valid tokens: FOR WITH ORDER UNION OPTIMI
版本:v4r3

踏雪有痕

这个是V5R3官方得例子，我以前用过，是好用得

Right Outer Join
A right outer join will return all the rows that an inner join returns plus one row for each of the other rows in the second table that did not have a match in the first table. It is the same as a left outer join with the tables specified in the opposite order.

The query that was used as the left outer join example can be rewritten as a right outer join as follows:

  SELECT EMPNO, LASTNAME, PROJNO
    FROM CORPDATA.PROJECT RIGHT OUTER JOIN CORPDATA.EMPLOYEE
          ON EMPNO = RESPEMP
    WHERE LASTNAME > 'S'
The results of this query are identical to the results from the left outer join query.

roden

应该是可以的,如果不行,把两个表调换下,再用LEFT JOIN

zysapply

left join:
SELECT A.fld1, IfNULL(B.fld2,'no') FROM filea A LEFT JOIN
fileb B ON A.fld1 = B.fld2               

5.4 4.5 均ＯＫ