Home RAP
New Blog Posts: Merging Reports - Part 1 and Part 2

Left outer join in queries

edited May 2010 in RAP
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?

Comments

  • edited May 2010
    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

This discussion has been closed.