Re: Bug with view definition?

Sebastian Böck wrote:
> Hello all,
>
> why is the last definition of a view not working, although the
> documentation says all three are equal?
>

>
> CREATE OR REPLACE VIEW not_working AS
>     SELECT one.*
>     FROM one.one, two.two
>     JOIN join1 ON join1.id = one.id;

I think it's trying to join "two" to "join1" - try
   ...FROM two.two, one.one
   JOIN join1...

--
   Richard Huxton
   Archonet Ltd