Page 1 of 1
Outer joins construction
Posted: Wed Jul 20, 2005 3:58 pm
by 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?
=> RE: Outer joins construction
Posted: Thu Jul 21, 2005 7:58 am
by 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