Page 1 of 1
Outer Join
Posted: Thu Oct 10, 2002 3:37 pm
by mharvanek
Is it possible to use an outer join within a SQL statement in version 2.0 against SQL Server 2000? We have tried (+) and OUTER JOIN and both of these cause a syntax error.
=> RE: Outer Join
Posted: Fri Oct 11, 2002 3:56 pm
by kfleming
Is this a user SQL report where you are writing the SELECT or an auto SQL report where you are editing the RSWSQL.INI?____Kathleen__R&R Support
==> RE: Outer Join
Posted: Fri Oct 11, 2002 4:11 pm
by mharvanek
It is a user SQL report.
===> RE: Outer Join
Posted: Sat Oct 12, 2002 12:10 pm
by kfleming
Try an auto sql outer join and see if that works. If so, use it^s syntax as a model.____Kathleen__R&R Support