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
Subject
Written By
Posted
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.