Outer joins construction

[P,_Luichinger_(Guest)]

Why does R&R create outer joins using the form {oj table_a left outer join table b on... etc. }? Is this ODBC compliant? Is there any way to leave out the {oj <some text> } but leave the text in-between?

[kfleming]

That syntax is ODBC compliant.__R&R uses three different outer join styles, the generic ODBC extended oj style that you reference and two different equality styles *= style WHERE clause join condition syntax or the "(+)" style WHERE clause join condition syntax.____Which syntax is used depends on the RSWSQL.INI setting that applies for a specific driver.____See the file RSWSQL.INI for more information.____Kathleen__R&R Support