in reply to DBI (DBD::Mysql) subquery issue

Which version of MySQL are you using? Subselects were only added in something like version 4.1 - and older versions are still very common.

--
<http://www.dave.org.uk>

"The first rule of Perl club is you do not talk about Perl club."
-- Chip Salzenberg