Re: Subquery and stored procedures

Article View: borland.public.interbase.sql

Article #929

Back to borland.public.interbase.sql Previous Next

#929

From: Svein Erling Tysvær
Date: Fri, 27 Apr 2007 10:27

28 lines
1633 bytes

What about

select t1.id, sp1.a, sp1.b
from tbl1 t1
left join storeproc1(t1.id) sp1 on (1=1)

Though I must admit that I only use a database similar to InterBase 
myself, and that it may or may not work.

Set

Luca Gallo (Gmg Sistemi) wrote:
> Hi all,
> Does someone know how to do something like this
> 
> select tbl1.id,(select a,b from storeproc1(tbl1.id)) from tbl1
> 
> Interbase give an sql error token unknow ,
> 
> I know i can do
> 
> select tbl1.id,(select a from storeproc1(tbl1.id)),(select b from 
> storeproc1(tbl1.id)) from tbl1
> 
> but this is much slower
> 
> TIA
> Luca

Technical Details

Message-ID: <4631d01c@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed0.kamp.net!newsfeed.kamp.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <4631c96e@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,815209dcccbc6914
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Fri, 27 Apr 2007 12:27:40 +0200
From: Svein Erling Tysvær
 <svein.erling.tysvaer@kreftregisteret.no>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: Subquery and stored procedures
References: <4631c96e@newsgroups.borland.com>
In-Reply-To: <4631c96e@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 84.49.7.130
Message-ID: <4631d01c@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1177669660 84.49.7.130 (27 Apr 2007 03:27:40 -0700)
Lines: 28
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed0.kamp.net!newsfeed.kamp.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message