Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Outer Join

2 posts in General Discussion Last posting was on 2012-01-05 22:15:12.0Z
Greens Posted on 2012-01-05 18:42:07.0Z
Sender: 3abb.4f05ee70.1804289383@sybase.com
From: Greens
Newsgroups: sybase.public.ase.general
Subject: Outer Join
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f05eeff.3ae7.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 5 Jan 2012 10:42:07 -0800
X-Trace: forums-1-dub 1325788927 172.20.134.41 (5 Jan 2012 10:42:07 -0800)
X-Original-Trace: 5 Jan 2012 10:42:07 -0800, 172.20.134.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30814
Article PK: 73708

Hi

I am getting different result set when using an outer join
between manually executing the query and running the same
through a stored procedure. Server is ASE15.0.3 ESD3. Any
ideas?

Thanks


Sherlock, Kevin [TeamSybase] Posted on 2012-01-05 22:15:12.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4f05eeff.3ae7.1681692777@sybase.com>
Subject: Re: Outer Join
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f0620f0$1@forums-1-dub>
Date: 5 Jan 2012 14:15:12 -0800
X-Trace: forums-1-dub 1325801712 10.22.241.152 (5 Jan 2012 14:15:12 -0800)
X-Original-Trace: 5 Jan 2012 14:15:12 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30815
Article PK: 73703

post code examples please.

<Greens> wrote in message news:4f05eeff.3ae7.1681692777@sybase.com...
> Hi
>
> I am getting different result set when using an outer join
> between manually executing the query and running the same
> through a stored procedure. Server is ASE15.0.3 ESD3. Any
> ideas?
>
> Thanks