Re: Query question

Just move table3 s to be last table specified before the left join phrase.

--
Nigel J. Andrews


On Thu, 28 Nov 2002, Björn Metzdorf wrote:

> Hi,
>
> This version should theoretically do what I want, but it does not work (it
> gives "ERROR:  Relation "s" does not exist"):
>
> ------ snip -------
> SELECT  m.*
> FROM  table1 m,
>    table2 ms,
>    table3 s,
>    table4 l
> LEFT JOIN table5 c ON s.id = ms.slot
> WHERE  m.id = 262451
> AND   ms.value2 = m.id
> AND   l.id = m.value
> AND   c.id = s.contestant
> ORDER BY m.date ASC
> ------ snap -------
>
>
> Thanks for your help.
>
> Regards,
> Bjoern