non-ANSI error from SQL

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

non-ANSI error from SQL

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

Post Reply