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@footballnet.com>
| Chief Operations Officer
| Football Networks Ltd
|-
| t:07976 625221
| f:0870 7060260
