RIGHT OUTER JOIN....

How to specifiy the RIGHT OUTER JOIN condition in the WHERE clause. I can
see the documentation for FROM clause.
I am using SQL 2K. Thanks for sharing syntax.
John
Hi,
Look Here:
Select O.OrderID from Orders O,Customers C Where
O.CustomerID =* C.CustomerID
But keep in mind:
From the SQL Server 6.5 Manual:
MSS SQL 6.5 MANUAL (EXCERPT)
=====================================
New join operators are available in SQL Server 6.5. Because future versions
of SQL Server may discontinue support for the "*=" and "=*" outer join
operators, it is recommended that you use the ANSI-standard join clauses
(LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN) instead.
HTH, Jens Smeyer.
"John Smith" <JSmith_SJ@.hotmail.com> schrieb im Newsbeitrag
news:O48PDd7PFHA.2736@.TK2MSFTNGP09.phx.gbl...
> How to specifiy the RIGHT OUTER JOIN condition in the WHERE clause. I can
> see the documentation for FROM clause.
> I am using SQL 2K. Thanks for sharing syntax.
> John
>
>
|||=+ But that syntax is considered "Deprecated"
Greg Jackson
PDX, Oregon
|||That syntax is Oracle (I believe). The SQL Server syntax is =*, which is deprecated and need db to
be in compat mode 80 to work in SQL Server 2005.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:uAWSDk7PFHA.3076@.TK2MSFTNGP14.phx.gbl...
> =+ But that syntax is considered "Deprecated"
>
> Greg Jackson
> PDX, Oregon
>
|||Jens,
Thanks for the reply.
What is the ANSI-standard syntax for WHERE clause outer join condition.
JS
"Jens Smeyer" <Jens@.sqlserver2005.de> wrote in message
news:OF1Ylh7PFHA.3076@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Look Here:
> Select O.OrderID from Orders O,Customers C Where
> O.CustomerID =* C.CustomerID
> But keep in mind:
> From the SQL Server 6.5 Manual:
> MSS SQL 6.5 MANUAL (EXCERPT)
> =====================================
> New join operators are available in SQL Server 6.5. Because future
versions[vbcol=seagreen]
> of SQL Server may discontinue support for the "*=" and "=*" outer join
> operators, it is recommended that you use the ANSI-standard join clauses
> (LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN) instead.
>
> HTH, Jens Smeyer.
>
> "John Smith" <JSmith_SJ@.hotmail.com> schrieb im Newsbeitrag
> news:O48PDd7PFHA.2736@.TK2MSFTNGP09.phx.gbl...
can
>
|||Hi John,
ANSI outer join syntax is:
select select_list
from table1 {left | right} [outer] join table2
on predicate
[join
restriction]look here:
http://manuals.sybase.com/onlinebook...R ESTART_N%25
HTH, Jens Smeyer.
http://www.sqlserver2005.de
"John Smith" <JSmith_SJ@.hotmail.com> schrieb im Newsbeitrag
news:Oiu21qEQFHA.3496@.TK2MSFTNGP12.phx.gbl...
> Jens,
> Thanks for the reply.
> What is the ANSI-standard syntax for WHERE clause outer join condition.
> JS
>
> "Jens Smeyer" <Jens@.sqlserver2005.de> wrote in message
> news:OF1Ylh7PFHA.3076@.TK2MSFTNGP14.phx.gbl...
> versions
> can
>
|||This syntax making join in the FROM clause.
What about the syntax related to WHERE clause.
John
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:Oi%23bsuEQFHA.3628@.TK2MSFTNGP15.phx.gbl...
> Hi John,
> ANSI outer join syntax is:
>
> select select_list
> from table1 {left | right} [outer] join table2
> on predicate
> [join
> restriction]look here:
>
http://manuals.sybase.com/onlinebook...R ESTART_N%25[vbcol=seagreen]
> HTH, Jens Smeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "John Smith" <JSmith_SJ@.hotmail.com> schrieb im Newsbeitrag
> news:Oiu21qEQFHA.3496@.TK2MSFTNGP12.phx.gbl...
clauses
>
|||There's no ANSI SQL syntax for formulating an OJ in the WHERE clause.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Smith" <JSmith_SJ@.hotmail.com> wrote in message news:eZLgHdFQFHA.2876@.TK2MSFTNGP10.phx.gbl...
> This syntax making join in the FROM clause.
> What about the syntax related to WHERE clause.
> John
>
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
> message news:Oi%23bsuEQFHA.3628@.TK2MSFTNGP15.phx.gbl...
> http://manuals.sybase.com/onlinebook...R ESTART_N%25
> clauses
>
|||There is none.
<WhereClauseForOuterJoins/>
"John Smith" <JSmith_SJ@.hotmail.com> schrieb im Newsbeitrag
news:eZLgHdFQFHA.2876@.TK2MSFTNGP10.phx.gbl...
> This syntax making join in the FROM clause.
> What about the syntax related to WHERE clause.
> John
>
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:Oi%23bsuEQFHA.3628@.TK2MSFTNGP15.phx.gbl...
> http://manuals.sybase.com/onlinebook...R ESTART_N%25
> clauses
>
|||Thank you all in participating in this topics.
John
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:eI0N10FQFHA.164@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> There is none.
> <WhereClauseForOuterJoins/>
> "John Smith" <JSmith_SJ@.hotmail.com> schrieb im Newsbeitrag
> news:eZLgHdFQFHA.2876@.TK2MSFTNGP10.phx.gbl...
http://manuals.sybase.com/onlinebook...R ESTART_N%25[vbcol=seagreen]
condition.[vbcol=seagreen]
join[vbcol=seagreen]
clause.
>

RIGHT OUTER JOIN....

How to specifiy the RIGHT OUTER JOIN condition in the WHERE clause. I can
see the documentation for FROM clause.
I am using SQL 2K. Thanks for sharing syntax.
JohnHi,
Look Here:
Select O.OrderID from Orders O,Customers C Where
O.CustomerID =* C.CustomerID
But keep in mind:
From the SQL Server 6.5 Manual:
MSS SQL 6.5 MANUAL (EXCERPT)
=====================================
New join operators are available in SQL Server 6.5. Because future versions
of SQL Server may discontinue support for the "*=" and "=*" outer join
operators, it is recommended that you use the ANSI-standard join clauses
(LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN) instead.
HTH, Jens Smeyer.
"John Smith" <JSmith_SJ@.hotmail.com> schrieb im Newsbeitrag
news:O48PDd7PFHA.2736@.TK2MSFTNGP09.phx.gbl...
> How to specifiy the RIGHT OUTER JOIN condition in the WHERE clause. I can
> see the documentation for FROM clause.
> I am using SQL 2K. Thanks for sharing syntax.
> John
>
>|||=+ But that syntax is considered "Deprecated"
Greg Jackson
PDX, Oregon|||That syntax is Oracle (I believe). The SQL Server syntax is =*, which is dep
recated and need db to
be in compat mode 80 to work in SQL Server 2005.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:uAWSDk7PFHA.3076@.TK2MSFTNGP14.phx.gbl...
> =+ But that syntax is considered "Deprecated"
>
> Greg Jackson
> PDX, Oregon
>|||Jens,
Thanks for the reply.
What is the ANSI-standard syntax for WHERE clause outer join condition.
JS
"Jens Smeyer" <Jens@.sqlserver2005.de> wrote in message
news:OF1Ylh7PFHA.3076@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Look Here:
> Select O.OrderID from Orders O,Customers C Where
> O.CustomerID =* C.CustomerID
> But keep in mind:
> From the SQL Server 6.5 Manual:
> MSS SQL 6.5 MANUAL (EXCERPT)
> =====================================
> New join operators are available in SQL Server 6.5. Because future
versions
> of SQL Server may discontinue support for the "*=" and "=*" outer join
> operators, it is recommended that you use the ANSI-standard join clauses
> (LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN) instead.
>
> HTH, Jens Smeyer.
>
> "John Smith" <JSmith_SJ@.hotmail.com> schrieb im Newsbeitrag
> news:O48PDd7PFHA.2736@.TK2MSFTNGP09.phx.gbl...
can[vbcol=seagreen]
>|||Hi John,
ANSI outer join syntax is:
select select_list
from table1 {left | right} [outer] join table2
on predicate
[join
restriction]look here:
http://manuals.sybase.com/onlineboo...qlserver2005.de
--
"John Smith" <JSmith_SJ@.hotmail.com> schrieb im Newsbeitrag
news:Oiu21qEQFHA.3496@.TK2MSFTNGP12.phx.gbl...
> Jens,
> Thanks for the reply.
> What is the ANSI-standard syntax for WHERE clause outer join condition.
> JS
>
> "Jens Smeyer" <Jens@.sqlserver2005.de> wrote in message
> news:OF1Ylh7PFHA.3076@.TK2MSFTNGP14.phx.gbl...
> versions
> can
>|||This syntax making join in the FROM clause.
What about the syntax related to WHERE clause.
John
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:Oi%23bsuEQFHA.3628@.TK2MSFTNGP15.phx.gbl...
> Hi John,
> ANSI outer join syntax is:
>
> select select_list
> from table1 {left | right} [outer] join table2
> on predicate
> [join
> restriction]look here:
>
http://manuals.sybase.com/onlineboo...RT_RESTART_N%25
> HTH, Jens Smeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "John Smith" <JSmith_SJ@.hotmail.com> schrieb im Newsbeitrag
> news:Oiu21qEQFHA.3496@.TK2MSFTNGP12.phx.gbl...
clauses[vbcol=seagreen]
>|||There's no ANSI SQL syntax for formulating an OJ in the WHERE clause.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Smith" <JSmith_SJ@.hotmail.com> wrote in message news:eZLgHdFQFHA.2876@.TK2MSFTNGP10.phx
.gbl...
> This syntax making join in the FROM clause.
> What about the syntax related to WHERE clause.
> John
>
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote i
n
> message news:Oi%23bsuEQFHA.3628@.TK2MSFTNGP15.phx.gbl...
> [url]http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@.ebt-link;pt=11971
;lang=de? target=%25N%15_12120_START_RESTART_N%25[
/url]
> clauses
>|||There is none.
<WhereClauseForOuterJoins/>
"John Smith" <JSmith_SJ@.hotmail.com> schrieb im Newsbeitrag
news:eZLgHdFQFHA.2876@.TK2MSFTNGP10.phx.gbl...
> This syntax making join in the FROM clause.
> What about the syntax related to WHERE clause.
> John
>
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:Oi%23bsuEQFHA.3628@.TK2MSFTNGP15.phx.gbl...
> [url]http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@.ebt-link;pt=11971
;lang=de? target=%25N%15_12120_START_RESTART_N%25[
/url]
> clauses
>|||Thank you all in participating in this topics.
John
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:eI0N10FQFHA.164@.TK2MSFTNGP12.phx.gbl...
> There is none.
> <WhereClauseForOuterJoins/>
> "John Smith" <JSmith_SJ@.hotmail.com> schrieb im Newsbeitrag
> news:eZLgHdFQFHA.2876@.TK2MSFTNGP10.phx.gbl...
http://manuals.sybase.com/onlineboo...RT_RESTART_N%25[vbcol=seagreen]
condition.[vbcol=seagreen]
join[vbcol=seagreen]
clause.[vbcol=seagreen]
>