query designer, "left outter join"

rbuser

In RB version 10.06 using the query designer, I find that when I add a table
with join type "Left Outer" the sql statement does not use a left join but
rather simply links it in. (The data retrived is not correct).

BTW. I recently removed the BDE in favor of Native DB. Some DataSettings
in the Designer are DatabaseType is dtSybaseASA, session type is NdbSession,
SQLType is sqSQL1. These are set per the daNDB_76.zip readme.doc.

Can you offer some guidance?

rbuser

From my experience with NexusDB and RB, you need to change the SQL type to
SQL2 to get the Left Outer Join to be inserted into the SQL code. SQL1 does
only inner joins.

rbuser

Thanks David.