Null values: specifiy

Showing posts with label specifiy. Show all posts

Friday, March 23, 2012

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 Süßmeyer.
"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 Süßmeyer" <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 Süßmeyer.
>
> "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
> >
> >
> >
> >
>|||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/onlinebooks/group-as/asg1250e/sqlug/@.ebt-link;pt=11971;lang=de?target=%25N%15_12120_START_RESTART_N%25
HTH, Jens Süßmeyer.
--
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 Süßmeyer" <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 Süßmeyer.
>>
>> "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
>> >
>> >
>> >
>> >
>>
>|||This syntax making join in the FROM clause.
What about the syntax related to WHERE clause.
John
"Jens Süßmeyer" <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/onlinebooks/group-as/asg1250e/sqlug/@.ebt-link;pt=11971;lang=de?target=%25N%15_12120_START_RESTART_N%25
> HTH, Jens Süßmeyer.
> --
> 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 Süßmeyer" <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 Süßmeyer.
> >>
> >>
> >>
> >> "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
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>|||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 Süßmeyer" <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/onlinebooks/group-as/asg1250e/sqlug/@.ebt-link;pt=11971;lang=de?target=%25N%15_12120_START_RESTART_N%25
>> HTH, Jens Süßmeyer.
>> --
>> 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 Süßmeyer" <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 Süßmeyer.
>> >>
>> >>
>> >>
>> >> "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
>> >> >
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>|||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 Süßmeyer" <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/onlinebooks/group-as/asg1250e/sqlug/@.ebt-link;pt=11971;lang=de?target=%25N%15_12120_START_RESTART_N%25
>> HTH, Jens Süßmeyer.
>> --
>> 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 Süßmeyer" <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 Süßmeyer.
>> >>
>> >>
>> >>
>> >> "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
>> >> >
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>|||Thank you all in participating in this topics.
John
"Jens Süßmeyer" <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...
> > This syntax making join in the FROM clause.
> > What about the syntax related to WHERE clause.
> > John
> >
> >
> > "Jens Süßmeyer" <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/onlinebooks/group-as/asg1250e/sqlug/@.ebt-link;pt=11971;lang=de?target=%25N%15_12120_START_RESTART_N%25
> >>
> >> HTH, Jens Süßmeyer.
> >>
> >> --
> >> 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 Süßmeyer" <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 Süßmeyer.
> >> >>
> >> >>
> >> >>
> >> >> "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
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>|||Last Question,
Wher exactly I can get the ANSI specification.
Thanks,
John
"John Smith" <JSmith_SJ@.hotmail.com> wrote in message
news:%23mTie$QQFHA.508@.TK2MSFTNGP12.phx.gbl...
> Thank you all in participating in this topics.
> John
> "Jens Süßmeyer" <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...
> > > This syntax making join in the FROM clause.
> > > What about the syntax related to WHERE clause.
> > > John
> > >
> > >
> > > "Jens Süßmeyer" <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/onlinebooks/group-as/asg1250e/sqlug/@.ebt-link;pt=11971;lang=de?target=%25N%15_12120_START_RESTART_N%25
> > >>
> > >> HTH, Jens Süßmeyer.
> > >>
> > >> --
> > >> 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 Süßmeyer" <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 Süßmeyer.
> > >> >>
> > >> >>
> > >> >>
> > >> >> "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
> > >> >> >
> > >> >> >
> > >> >> >
> > >> >> >
> > >> >>
> > >> >>
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
>|||Look at my previous post, or search in google for. There are tons of hits
for it.
Jens Süßmeyer.
"John Smith" <JSmith_SJ@.hotmail.com> schrieb im Newsbeitrag
news:eNq4aERQFHA.2132@.TK2MSFTNGP09.phx.gbl...
> Last Question,
> Wher exactly I can get the ANSI specification.
> Thanks,
> John
>
> "John Smith" <JSmith_SJ@.hotmail.com> wrote in message
> news:%23mTie$QQFHA.508@.TK2MSFTNGP12.phx.gbl...
>> Thank you all in participating in this topics.
>> John
>> "Jens Süßmeyer" <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...
>> > > This syntax making join in the FROM clause.
>> > > What about the syntax related to WHERE clause.
>> > > John
>> > >
>> > >
>> > > "Jens Süßmeyer" <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/onlinebooks/group-as/asg1250e/sqlug/@.ebt-link;pt=11971;lang=de?target=%25N%15_12120_START_RESTART_N%25
>> > >>
>> > >> HTH, Jens Süßmeyer.
>> > >>
>> > >> --
>> > >> 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 Süßmeyer" <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 Süßmeyer.
>> > >> >>
>> > >> >>
>> > >> >>
>> > >> >> "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
>> > >> >> >
>> > >> >> >
>> > >> >> >
>> > >> >> >
>> > >> >>
>> > >> >>
>> > >> >
>> > >> >
>> > >>
>> > >>
>> > >
>> > >
>> >
>> >
>>
>

Friday, March 23, 2012

RIGHT OUTER JOIN....

RIGHT OUTER JOIN....

RIGHT OUTER JOIN....

Null values

Blog Archive

About Me