Richard Huxton wrote:
> 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...
Sure, but the problem still exists if you want to join with table one
and table two.
Forgot to say that this also applies for normal selects (of course!).
Sebastian