Page 1 of 1

non-ANSI error from SQL

Posted: Fri Sep 16, 2011 10:02 am
by Rao_(Guest)
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