MySQL Forums
Forum List  »  Microsoft SQL Server

Re: valid sql doesnt works
Posted by: Sean Nolan
Date: April 12, 2005 09:58AM

What version of MySQL are you using? Version earlier than 4.1 do not support subqueries, so then that is not valid SQL.

You should rather rewrite that query using a join anyway, so this will work and is better SQL

SELECT fotos.* FROM fotos
INNER JOIN albums ON fotos.IDalbum = albums.IDalbum
WHERE albums.IDusuario = 13

Sean Nolan

Options: ReplyQuote

Written By
April 10, 2005 03:45PM
Re: valid sql doesnt works
April 12, 2005 09:58AM

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.