RTVQMQRY anomaly?

["Richard B Baird" <rbaird@xxxxxxxxxxxxxxxxxxxxx>]

Hey all,

I created a qry/400 query, joining two files (option 3=Unmatched records
with primary file).   I saved the query and did a RTVQMQRY to see what the
sql statement should look like.

what I got was a simple join:

SELECT
  ALL       T01.ORG, T01.VENID, T01.ORIGORG
            T01.INVOICE
  FROM      M30DAP/VOL0 T01,
            M30DAP/VOH0 T02
  WHERE     T01.ORG = T02.ORG
    AND     T01.VENID = T02.VENID
    AND     T01.ORIGORG = T02.ORIGORG
    AND     T01.VCHNBR = T02.VCHNBR

shouldn't this have been a 'left outer join'?  I ran the SQL statement and
got completely different results than the first.  What gives?

I'm on V4R5.

Thanks!

Rick