Left outer join in queries

rbuser

I am building a report which requires a left outer join. In the Data tab of
the report designer I join 2 tables using a left outer join.

I would expect the SQL created to look like this:

SELECT SALESORD_HDR.SEQNO, SALESORD_HDR.STATUS,
SALESORD_HDR.ACCNO,
NARRATIVES.NARRATIVE
FROM SALESORD_HDR SALESORD_HDR
LEFT OUTER JOIN NARRATIVES NARRATIVES ON
(NARRATIVES.SEQNO = SALESORD_HDR.NARRATIVE_SEQNO)

What it is creating is this:

SELECT SALESORD_HDR.SEQNO, SALESORD_HDR.STATUS,
SALESORD_HDR.ACCNO,
NARRATIVES.NARRATIVE
FROM SALESORD_HDR SALESORD_HDR
, NARRATIVES NARRATIVES
WHERE
(NARRATIVES.SEQNO = SALESORD_HDR.NARRATIVE_SEQNO)


Am I missing one of the magical undocumented units from my uses clause? Is
there a setting in Report Builder that I have missed?

rbuser

Found the answer -

In the Data Tab you need to go File -> Data Settings -> SQL and then select
SQL Type of "SQL2" and then it appears to work.


Found that I had to set it in the designer component.

Thanks,

Steve