On Fri, Feb 13, 2004 at 02:13:11 +0200,
Zak McGregor <zak@mighty.co.za> wrote:
>
> I'd like to join them somehow to get the following:
>
> fixtureid | home_team | count1 | away_team | count2
> -----------+-----------+--------+-------------+-------
> 2872 | Kat Fish | 12 | A Cut Above | 13
> 2944 | The Fowls | 11 | Kat Fish | 14
>
>
>
> Can anyone spot a reasonable way to do that please?
The simplest way given what you've got already is to make each of the
two selects a from item and join them on fixtureid.
That probably isn't the most efficient way to do it, but should get you
going for now.
