> 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
> 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
> WH
This is my first email to the list, so be nice ;-)
I'm having some difficulty with a subquery that I'm trying to do, and was
wondering if anyone here can shed some light on the issue...
This query returns a result as expected:
SELECT id FROM client_list WHERE name="Some Company"
(the id returned
