On Sat, 5 Jun 2004 21:10:42 -0600 "Daniel Isenhower" <[EMAIL PROTECTED]> wrote:
> > First off, I assume you are using a version of mysql able to > > handle > sub-queries. 4.1 or 5.0 (4.0.xx does NOT support sub-queries) > > Ugh... I feel dumb :).... I'm using 4.0 No worries, there are too many versions of MySQL to choose from... > > FWIW, this is an easy query with a JOIN: > > > > SELECT id FROM work w > > INNER JOIN client_list cl ON cl.id = w.client_id > > WHERE cl.name = 'Some Company'; > > > > Just in case you are using mysql 4.0 or earlier... > > Thanks very much! This is what I need :) > > Also, while I'm at it, any book recommendations for getting to know > MySQL better? I've always liked the reference manual, but it's essentially a reprint of the online documentation, which is excellent. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]