MySQL Forums
Forum List  »  Newbie

Problem with MSSQL query syntax vs. MYSQL query syntax
Posted by: lqqker lqqker
Date: April 14, 2005 01:46PM

Hello,
Can someone please tell me why the below query in MSSQL works but in MYSQL it gives me an error.

select distinct systems.ip from services inner join systems on services.ip = systems.ip where running like 'Microsoft%' and not exists(Select port from services where services.ip = systems.ip and port = 8081);

the error it comes back with is this.

ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'exists(Select port from services where services.ip = systems.ip


Thanks in advance for any help you can give a newbie :-)

Options: ReplyQuote


Subject
Written By
Posted
Problem with MSSQL query syntax vs. MYSQL query syntax
April 14, 2005 01:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.