MySQL Forums
Forum List  »  Sybase

Re: SQL statment from Sybase SqlAnywhere 11 to MySql
Posted by: Claude Veigas
Date: July 18, 2010 06:53AM

Hey Alex,
Try and run the subquery on it's own and you may notice that it returns more than 1 row.

A subquery in an update statement HAS to return only 1 row to work.

Cheers,
Claude

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: SQL statment from Sybase SqlAnywhere 11 to MySql
3934
July 18, 2010 06:53AM


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.