Using the example:
SELECT '' AS "xxx", *
FROM J1_TBL LEFT OUTER JOIN J2_TBL USING (i);
..doesn't work because the columns which I am using to join the tables don't
have the same name. How do i specify the columns if they don't have the same
name?
Poul L. Christiansen
Tom Lane wrote:
<pre wr=
ap=3D"">"Poul L. Christiansen" <a class=3D"moz-txt-link-rfc2396E" href=3D"m=
ailto:poulc@cs.auc.dk"><poulc@cs.auc.dk> writes:
But how do I make an outer join?=
What's the syntax?I will RTFM if someone points me to the docs :-)=
I'm afraid I haven't updated the FM yet :-( .=
.. but you could look atthe examples in the JOIN regress test, src/test=
/regress/sql/join.sql.Or, from the SQL92 spec, here's the grammar:<=
br> <from clause> ::=3D FROM <table reference> [ { =
<comma> <table reference> }... ] <table refe=
rence> ::=3D <table name> [ [ AS ] <correlat=
ion name> [ <left paren> <derived column=
list> <right paren> ] ] | <derived table> =
[ AS ] <correlation name> [ <left paren>=
<derived column list> <right paren> ] | <j=
oined table> <derived table> ::=3D <table subqu=
ery> <derived column list> ::=3D <column name l=
ist> <column name list> ::=3D <=
;column name> [ { <comma> <column name> }...