DB Access error - outer join

[jgould4857]

I^m using R&R SQL 12.1.001____I have a simple report (no filter) that connects 3 tables together for auditing purposes. One of the connections requires an outer join. When executing this report, the following error message immediately appears.____DB Access: [Microsoft][ODBC SQL Server Driver][SQL Server]Joined tables cannot be specified in a query containing outer join operators. View or function ^dbo.vwppridplay2^ contains joined tables. [Microsoft][ODBC SQL Server Driver][SQL Server] Statement(s) could not be prepared.____this report does not use a filter/query and the tables are relatively small.____Please help.____Jonathan__

[kfleming]

If this is SQL Server, edit the file RSWSQL.INI that is in the RSW.EXE program folder and edit the line DataSourceOuterJoinStyle = 1__that is in the SQL Server section and add a semicolon so that it looks as shown below and see if this helps.____;;;;;;;;;;;;;;;;;;;;;;__;;; ;;;__;;; SQL Server ;;;__;;; ;;;__;;;;;;;;;;;;;;;;;;;;;;__[SQLServer]__DataSourceDBMS = Microsoft SQL SERVER__;DataSourceOuterJoinStyle = 1______Kathleen__R&R Support

[jgould4857]

That did the trick. Perfect____Thanks!!