Greg Stark writes:
>
> Harry Broomhall <harry.broomhall@uk.easynet.net> writes:
>
> > I'm not entirely sure how I would do this, as the 'lookup' is actualy
> > a join. I thought that the order of nameing the joined tables didn't
> > matter (except for 'left' and 'right'), similar to the fact that 1 + 2 is
> > the same as 2 + 1.
>
> Outer joins are commutative (1+2 == 2+1) at least barring the left/right
> issue. But they are not associative. (1+2)+3 != 1+(2+3).
Thanks for the info. I was fairly sure that both the above were true,
but it is nice to be certain!
Regards,
Harry.