out join, need configuration?

Hello:
I tried a query with outer join in SQL Analyzer, but it does not work as
expected. Is there any configuration/setting I need to do in SQL server, in
order to make it work?
Thanks.
QHi,
There is no configuration change need to be made to make outer joins change
its behaviour.
Thanks
Hari
SQL Server MVP
"Q" <Q@.discussions.microsoft.com> wrote in message
news:7ACD64A0-A4C2-4BF4-BDE0-36C3A26469AD@.microsoft.com...
> Hello:
> I tried a query with outer join in SQL Analyzer, but it does not work as
> expected. Is there any configuration/setting I need to do in SQL server,
in
> order to make it work?
> Thanks.
> Q|||Hi
There are no setting that are required to be changed.
Probably you require to change the order of the TABLES that you are using.
LEFT / RIGHT OUTER Joins..
Hope this solved your problem
thanks and regards
Chandra
"Q" wrote:
> Hello:
> I tried a query with outer join in SQL Analyzer, but it does not work as
> expected. Is there any configuration/setting I need to do in SQL server, in
> order to make it work?
> Thanks.
> Q|||Thanks for all your replies! For some reason LEFT/RIGHT outer does not work.
But *= or =* does work.
Q
"Chandra" wrote:
> Hi
> There are no setting that are required to be changed.
> Probably you require to change the order of the TABLES that you are using.
> LEFT / RIGHT OUTER Joins..
> Hope this solved your problem
> thanks and regards
> Chandra
>
> "Q" wrote:
> > Hello:
> >
> > I tried a query with outer join in SQL Analyzer, but it does not work as
> > expected. Is there any configuration/setting I need to do in SQL server, in
> > order to make it work?
> >
> > Thanks.
> >
> > Q|||My guess is that you are filtering in the WHERE clause and for an ANSI join, you need to put that
filter in the FROM clause. "Doesn't work" is not a good problems description. Posting the error
message, or describing in what way you get unexpected result back is a better problem description.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Q" <Q@.discussions.microsoft.com> wrote in message
news:F911E946-0796-49C9-B665-27525C761E32@.microsoft.com...
> Thanks for all your replies! For some reason LEFT/RIGHT outer does not work.
> But *= or =* does work.
> Q
> "Chandra" wrote:
>> Hi
>> There are no setting that are required to be changed.
>> Probably you require to change the order of the TABLES that you are using.
>> LEFT / RIGHT OUTER Joins..
>> Hope this solved your problem
>> thanks and regards
>> Chandra
>>
>> "Q" wrote:
>> > Hello:
>> >
>> > I tried a query with outer join in SQL Analyzer, but it does not work as
>> > expected. Is there any configuration/setting I need to do in SQL server, in
>> > order to make it work?
>> >
>> > Thanks.
>> >
>> > Q