Outer Join

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
mharvanek
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

Outer Join

Post by mharvanek » Thu Oct 10, 2002 3:37 pm

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.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Outer Join

Post by kfleming » Fri Oct 11, 2002 3:56 pm

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

mharvanek
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Outer Join

Post by mharvanek » Fri Oct 11, 2002 4:11 pm

It is a user SQL report.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: Outer Join

Post by kfleming » Sat Oct 12, 2002 12:10 pm

Try an auto sql outer join and see if that works. If so, use it^s syntax as a model.____Kathleen__R&R Support

Post Reply