MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Subqueries
Posted by: Russ Abbott
Date: August 19, 2004 08:13PM

I'm having the same problem. No matter how simple the subquery, I get an error message. For example,

MySQL error 1064: You have an error in your SQL syntax near 'SELECT id FROM pages) ' at line 2
When executing:
SELECT * FROM page_archive WHERE id IN (SELECT id FROM pages)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Subqueries
Phil Haigh
August 19, 2004 05:02AM
Re: Subqueries
philip antoniades
August 19, 2004 02:13PM
Re: Subqueries
Phil Haigh
August 20, 2004 01:54AM
Re: Subqueries
Russ Abbott
August 19, 2004 08:13PM
Re: Subqueries
Russ Abbott
August 19, 2004 08:14PM
Re: Subqueries
Phil Haigh
August 20, 2004 01:56AM


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.