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