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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
