How Do I Perform An Outer Join?

1.	How Do I Perform An Outer Join?
Answer» PostgreSQL supports outer joins USING the SQL standard syntax. Here are two EXAMPLES: SELECT * FROM t1 LEFT OUTER JOIN t2 ON (t1.COL = t2.col); or SELECT * FROM t1 LEFT OUTER JOIN t2 USING (col); PostgreSQL supports outer joins using the SQL standard syntax. Here are two examples: SELECT * FROM t1 LEFT OUTER JOIN t2 ON (t1.col = t2.col); or SELECT * FROM t1 LEFT OUTER JOIN t2 USING (col);

Answer»

PostgreSQL supports outer joins USING the SQL standard syntax. Here are two EXAMPLES:

SELECT * FROM t1 LEFT OUTER JOIN t2 ON (t1.COL = t2.col);
or
SELECT * FROM t1 LEFT OUTER JOIN t2 USING (col);

PostgreSQL supports outer joins using the SQL standard syntax. Here are two examples:

SELECT * FROM t1 LEFT OUTER JOIN t2 ON (t1.col = t2.col);
or
SELECT * FROM t1 LEFT OUTER JOIN t2 USING (col);

Discussion