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.
Q
Hi,
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:
[vbcol=seagreen]
> 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:
|||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...[vbcol=seagreen]
> Thanks for all your replies! For some reason LEFT/RIGHT outer does not work.
> But *= or =* does work.
> Q
> "Chandra" wrote: