Re: INNER JOINS in 7.0.3 & 7.1.3

On Tuesday 30 October 2001 16:23 pm, Keary Suska wrote:
> IIRC You can't have multiple join clauses, per se, but you can "chain"
> joins. I am not sure how that is done with a self join, but since inner
> joins are implicit why not just:
>
> SELECT a.name as hometeam, c.name as homemanager, c.email as homeemail,
> b.name as awayteam, d.name as awaymanager, d.email as awayemail
> FROM teams a, managers c, teams b, managers d
> where a.managerid = c.managerid AND b.managerid = d.managerid AND a.teamid
> = 13 AND b.teamid = 15;

That's the way I had it at some point in the dev process, but I switched over
to using joins to try and realise some performance increase.

--

| Stuart Grimshaw <stuart(at)footballnet(dot)com>
| Chief Operations Officer
| Football Networks Ltd
|-
| t:07976 625221
| f:0870 7060260