non-ANSI error from SQL

Rao_(Guest) · Post by **Rao_(Guest)** » Fri Sep 16, 2011 10:02 am

Iam using R&R SQL V12. When I join two tables through JOIN option in R&R following error is thrown.____The query uses non-Ansi outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level......... In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes.____When I use JOIN funtion, R&R is internally using non-Ansi operators to form a query. How do I make it work?____Thanks