First page Back Continue Last page Overview Graphics
Oracle'dan PostgreSQL'e geçiş – Outer Joinler (Peter Eisentraut)
SELECT * FROM t1, t2, t3
WHERE t1.c1 (+) = t2.c2
AND t3.c3(+) = t2.c2
PostgreSQL:
SELECT * FROM t1
RIGHT JOIN
t2 ON (t1.c1 = t2.c2)
LEFT JOIN
t3 ON (t3.c3 = t2.c2)