now **exactly** what you’re sending to mysql.
>
>
>
> Regards,
>
> Gavin Towey
>
>
>
> *From:* Victor Subervi [mailto:victorsube...@gmail.com]
> *Sent:* Thursday, October 01, 2009 3:04 PM
>
> *To:* Gavin Towey; mysql@lists.mysql.com
> *Subject:* Re: Nested Join
g the query you're building to a string, then printing it out so you
know *exactly* what you're sending to mysql.
Regards,
Gavin Towey
From: Victor Subervi [mailto:victorsube...@gmail.com]
Sent: Thursday, October 01, 2009 3:04 PM
To: Gavin Towey; mysql@lists.mysql.com
Subject: Re: Nested Jo
ictor Subervi [mailto:victorsube...@gmail.com]
> *Sent:* Thursday, October 01, 2009 2:25 PM
> *To:* Gavin Towey; mysql@lists.mysql.com
> *Subject:* Re: Nested Joins
>
>
>
> On Thu, Oct 1, 2009 at 4:03 PM, Gavin Towey wrote:
>
> Joins aren't nested like that, unless yo
s/articles/mysql-db-design-ch5.pdf
http://dev.mysql.com/doc/refman/5.1/en/join.html
Regards,
Gavin Towey
From: Victor Subervi [mailto:victorsube...@gmail.com]
Sent: Thursday, October 01, 2009 2:25 PM
To: Gavin Towey; mysql@lists.mysql.com
Subject: Re: Nested Joins
On Thu, Oct 1, 2009 at 4:03
On Thu, Oct 1, 2009 at 4:03 PM, Gavin Towey wrote:
> Joins aren't nested like that, unless you use a subquery. I think you just
> need to remove the parens around the second join.
>
I tried that and no go :(
>
> For better help:
> 1. show the real SQL -- echo the statement. Most people here d
Joins aren't nested like that, unless you use a subquery. I think you just
need to remove the parens around the second join.
For better help:
1. show the real SQL -- echo the statement. Most people here don't like
looking at app code because your variables could contain anything.
2. Give the
