On Dec 31, 6:26 am, "Daniel Kaplan" <NoS...@NoSpam.com> wrote:
> "Daniel Kaplan" <NoS...@NoSpam.com> wrote in message
>
> news:1198949293.695097@nntp.acecape.com...
>
> For those finding this thread looking for the same answer, it appears that
> what I was trying:
>
> select orderid from bOrders where userid IN (select userid from email =
> 'J...@abc.com');
>
> should have worked all along. But posting somewhere else I saw that someone
> mentioned the version of MySQL. Turns out you need to be running at least
> version 4.1 or higher of MySQL. I am not. So either figure out the whole
> join thing, or upgrade your MySQL. I'm going to try and get my datacenter
> to upgrade it.
>
> *** please not that this is not tested yet.
>
> And for those who were just following this thread from the side, yeah, sorry
> for the whole thing.
>
> Thanks as always

or just use a JOIN