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.

Left Outer Joins in SQL

4 posts in PB Infomaker Report Writer Last posting was on 2010-06-01 14:09:23.0Z
Harvard Kinkead Posted on 1998-03-18 08:36:42.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 18 Mar 1998 00:36:42 -0800
From: Harvard Kinkead <hneal@idt.net>
Reply-To: hneal@idt.net
X-Mailer: Mozilla 4.01 [en] (Win95; I)
MIME-Version: 1.0
Subject: Left Outer Joins in SQL
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 26
Message-ID: <348_350F8799.8BC8A156@idt.net>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7214
Article PK: 243243

When I create reports I generally use the SQL instead of the painter. I
am presently working with three tables. A Provider table, a License
table, and a DEA table. The provider table links to the other two
tables by a Provider ID. The License table only has a record for a
provider who's license we have. The DEA table only has records for a
provider who's DEA we have. For me to print all Providers with their
Licenses and DEAs, I need to create two left-outer-joins connecting the
Provider table to both the License table and the DEA table. However,
when I do this, I get Select Syntax Error message. If I perform just
one Left outer join, it works fine. I also tried using the graphic
representation of the SQL (sorry, I never paid enough attention to
recall what it is called) and then convert it to SQL, and it still gave
me the error. It even gave me the error when I tried using the report
without converting it to SQL. I have a great need for this particular
usage. Can anyone help.

Thanks


Harvard Kinkead Posted on 2010-06-01 09:31:14.0Z
From: "Harvard Kinkead" <hneal2009@gmail.com>
Newsgroups: sybase.public.infomaker.general
Subject: Re: Left Outer Joins in SQL
References: <348_350F8799.8BC8A156@idt.net>
X-Newsreader: newsgroupstats.hk
X-HTTP-Posting-Host: 74.100.66.54
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c04d362$1@forums-1-dub>
Date: 1 Jun 2010 02:31:14 -0700
X-Trace: forums-1-dub 1275384674 10.22.241.152 (1 Jun 2010 02:31:14 -0700)
X-Original-Trace: 1 Jun 2010 02:31:14 -0700, vip152.sybase.com
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.infomaker.general:13207
Article PK: 233401

--
Android Usenet Reader
http://android.newsgroupstats.hk

Free News Reader
http://put.hk
http://put.hk/reader/forums.sybase.com/sybase.public.infomaker.general.html

Harvard Kinkead <hneal@idt.net> wrote:
> When I create reports I generally use the SQL instead of the painter. I
> am presently working with three tables. A Provider table, a License
> table, and a DEA table. The provider table links to the other two
> tables by a Provider ID. The License table only has a record for a
> provider who's license we have. The DEA table only has records for a
> provider who's DEA we have. For me to print all Providers with their
> Licenses and DEAs, I need to create two left-outer-joins connecting the
> Provider table to both the License table and the DEA table. However,
> when I do this, I get Select Syntax Error message. If I perform just
> one Left outer join, it works fine. I also tried using the graphic
> representation of the SQL (sorry, I never paid enough attention to
> recall what it is called) and then convert it to SQL, and it still gave
> me the error. It even gave me the error when I tried using the report
> without converting it to SQL. I have a great need for this particular
> usage. Can anyone help.
> Thanks


"Paul Horan[Sybase]" <phoran_remove Posted on 2010-06-01 14:09:23.0Z
From: "Paul Horan[Sybase]" <phoran_remove@remove_sybase.com>
Newsgroups: sybase.public.infomaker.general
References: <348_350F8799.8BC8A156@idt.net> <4c04d362$1@forums-1-dub>
Subject: Re: Left Outer Joins in SQL
Lines: 44
Organization: Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c051493$1@forums-1-dub>
Date: 1 Jun 2010 07:09:23 -0700
X-Trace: forums-1-dub 1275401363 10.22.241.152 (1 Jun 2010 07:09:23 -0700)
X-Original-Trace: 1 Jun 2010 07:09:23 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.infomaker.general:13209
Article PK: 233402

Not enough information to help...

Which database are you using?
What version/build of IM?
Can you post the syntax of the query you're trying?
What's the exact error message?

--
Paul Horan[Sybase]
http://blogs.sybase.com/phoran/

"Harvard Kinkead" <hneal2009@gmail.com> wrote in message
news:4c04d362$1@forums-1-dub...
>
>
> --
> Android Usenet Reader
> http://android.newsgroupstats.hk
>
> Free News Reader
> http://put.hk
> http://put.hk/reader/forums.sybase.com/sybase.public.infomaker.general.html
>
> Harvard Kinkead <hneal@idt.net> wrote:
>> When I create reports I generally use the SQL instead of the painter. I
>> am presently working with three tables. A Provider table, a License
>> table, and a DEA table. The provider table links to the other two
>> tables by a Provider ID. The License table only has a record for a
>> provider who's license we have. The DEA table only has records for a
>> provider who's DEA we have. For me to print all Providers with their
>> Licenses and DEAs, I need to create two left-outer-joins connecting the
>> Provider table to both the License table and the DEA table. However,
>> when I do this, I get Select Syntax Error message. If I perform just
>> one Left outer join, it works fine. I also tried using the graphic
>> representation of the SQL (sorry, I never paid enough attention to
>> recall what it is called) and then convert it to SQL, and it still gave
>> me the error. It even gave me the error when I tried using the report
>> without converting it to SQL. I have a great need for this particular
>> usage. Can anyone help.
>> Thanks
>
>


Terry Dykstra [TeamPS] Posted on 1998-03-18 18:00:44.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Left Outer Joins in SQL
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Wed, 18 Mar 1998 13:00:44 -0500
Lines: 38
Message-ID: <348_01bd52a0$ff237240$3301020a@tdykstra>
References: <348_350F8799.8BC8A156@idt.net>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7213
Article PK: 243246

This could be a limitation of the DBMS itself. To get around it you can
use a UNION:
select p.*, l.xxx, null
from provider p, license l
where p.provider_id = l.provider_id (+)
union all
select p.*, null, d.xxx
from provider p, dea d
where p.provider_id = d.provider_id (+)
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Harvard Kinkead <hneal@idt.net> wrote in article
<350F8799.8BC8A156@idt.net>...
> When I create reports I generally use the SQL instead of the painter. I
> am presently working with three tables. A Provider table, a License
> table, and a DEA table. The provider table links to the other two
> tables by a Provider ID. The License table only has a record for a
> provider who's license we have. The DEA table only has records for a
> provider who's DEA we have. For me to print all Providers with their
> Licenses and DEAs, I need to create two left-outer-joins connecting the
> Provider table to both the License table and the DEA table. However,
> when I do this, I get Select Syntax Error message. If I perform just
> one Left outer join, it works fine. I also tried using the graphic
> representation of the SQL (sorry, I never paid enough attention to
> recall what it is called) and then convert it to SQL, and it still gave
> me the error. It even gave me the error when I tried using the report
> without converting it to SQL. I have a great need for this particular
> usage. Can anyone help.
>
> Thanks
>
>