out joins problem

rbuser

I am using RB 7.03. When I build the sql statement using the query wizard
or query designer, I can select to have tables join as left outer and right
outer. However, the outer joins do not appear to work based on the sql
statement generated and the resulting data records.

Is there a setting I have missed or a bug? Obviously this is pretty
critical to accurate reporting.

Thanks,
BT

nardmoseley

For the Designer.DataSettings check that you are using the correct values
for DatabaseType and SQLType.

You have not specified what database product your are using. Outer join
syntax varies from product to product quite a bit. If the settings above do
not work, we need more details.


--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

rbuser

I had theDatabaseType set to dtMSSQLServer and the SQLType set to sqSQL1.
It appears to work but the Left / Right Outer Joins do not effect the SQL
statement generated. I just changed to SQL3 for the SQLType and the problem
is resolved.

Thank you for the solution.

Thanks,
Bob