[Firebird-odbc-devel] Crystal Reports registry patch

[Kevin S. <kev...@at...>]

Thanks Dimitry!

I ran outjoin.reg (from your link) to create the Outerjoin folder in the
registry at
Hkey_Current_User / Software / Seagate Software / Crystal Reports /
DatabaseOptions / Outerjoin

Then I added the "odbcjdbc" driver name to the "PlusEqual" section within
"Outerjoin" and Crystal now generates much different SQL (below):

SELECT
    PATIENT1."NAMEFIRST", PATIENT1."NAMELAST",
    PATIENT1."PATIENTID", PATIENT1."PROVIDERID",
    PROVIDER1."NAMEFIRST", PROVIDER1."NAMELAST"
FROM
    "PATIENT" PATIENT1,
    "PROVIDER" PROVIDER1
WHERE
    PATIENT1."PROVIDERID" = PROVIDER1."PROVIDERID" AND
    PATIENT1."PATIENTID" < 2000
ORDER BY
    PATIENT1."PROVIDERID" ASC

Most importantly -- it works!

Being a novice with SQL, I still don't understand why the SQL is created
using "alias names" (my term, probably very wrong) to the two tables
(PATIENT1 instead of PATIENT and PROVIDER1 instead of PROVIDER).  It would
seem more direct to simply reference the actual table names.  What am I
missing?


Thanks for your help!
Kevin.


Previous code included below for reference:

SELECT
    PATIENT1."NAMEFIRST", PATIENT1."NAMELAST",
    PATIENT1."PATIENTID", PATIENT1."PROVIDERID",
    PROVIDER1."NAMENAMEFIRST", PROVIDER1."NAMELAST"
FROM
    { oj "PATIENT" PATIENT1 INNER JOIN "PROVIDER" PROVIDER1 ON
        PATIENT1."PROVIDERID" = PROVIDER1."PROVIDERID"}
WHERE
    PATIENT1."PATIENTID" < 2000
ORDER BY
    PATIENT1."PROVIDERID" ASC