General SQL error. Query is not Working

Asked By petersulliva 0 points N/A Posted on - 09/13/2011

I am using MySQL.

Today I wrote one SQL query and tried to execute it. But it generates the below error for me.

In this query I am using an outer join operator. 

I created one table now and I want to get some useful information by applying this query.

Can anyone tell me more details about this error?

General SQL error.

The query uses non-ANSI outer joint operators (“*=” or “=*”). To run this query without modification, please set the compatible.

OK

• Status: Open
• Question Views: 1542
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By James.Daived 0 points N/A #95869

General SQL error. Query is not Working

Hello,

As it appears to you. This error is related to the syntax for your query. You wrote your query using operators like *= or something like that. This way of writing queries is not supported any more by Microsoft SQL server.

As in the new versions Microsoft cancelled the support for using operators as you used. But I think that you tried it before with lower versions of Microsoft SQL server and it worked well.

So, it is not hard to fix this error. Just, all what you need is to apply your query to a previous version of Microsoft SQL server and this step can be done by your database administrator. He has to change the database compatibility to be 80, which refers to Microsoft SQL server 2000.

The best solution:

Is to rewrite your query in the new standard of Microsoft SQL server and to avoid the old style of used join operators.

Hope it helps you.

James

About James.Daived

Questions
0

Answers
5

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 09/13/2011
• Question Category: MySQL Server