Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
SELECT venue_id FROM
     (SELECT venue_id FROM nightave_dNightAve.statistics
     ) as tbl

I keep getting............

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 'SELECT venue_id FROM statistics
     ) as t

I'm running MySQL Version 4.0.22

Re: subquery

Quoted text here. Click to load it
MySQL did not support subqueries in that version.

Re: subquery

Try using temporary tables instead of a subquery.

Quoted text here. Click to load it

Site Timeline