Read the manual. MySQL doesn't support subselects but offers you alternatives.
On Monday 15 April 2002 2:45 pm, Jeff Shipman wrote: > I'm trying to do a fairly simple select of a > column from a table where the date of that column > happens to be the highest value. I tried this: > > SELECT name FROM products WHERE prod_type='foo' AND > added=(SELECT MAX(added) FROM products WHERE > prod_type='foo'); > > But I get the error: > > ERROR 1064: You have an error in your SQL syntax > near 'SELECT MAX(added) FROM products WHERE > prod_type='foo')' at line 1 > > Is there a problem with the parentheses? I've > used this syntax with Oracle before with no > troubles. > > name and prod_type are TINYTEXT and added is > a DATE. > > Is there another way I should be doing this? I > could probably order descending by the added date > and then just LIMIT 1, but I don't think that's > very clean. > > 'mysql --version' returns: > > mysql Ver 11.15 Distrib 3.23.41, for -freebsd4.4 (i386) > > Thanks in advance, --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
