Re: Subquery and stored procedures

Article View: borland.public.interbase.sql

Article #931

Back to borland.public.interbase.sql Previous Next

#931

From: Luca Gallo (Gmg Sistemi)
Date: Wed, 02 May 2007 12:29

36 lines
1893 bytes

It works,
I must admit that nothing is like asking and gettings answers

many thanks
Luca

"Svein Erling Tysv�r" <svein.erling.tysvaer@kreftregisteret.no> ha scritto 
nel messaggio news:4631d01c@newsgroups.borland.com...
> 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: <46388430@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

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

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,815209dcccbc6914
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII
Reply-To: "Luca Gallo \(Gmg Sistemi\)" <luca.gallo@gmgsistemi.it>
From: "Luca Gallo \(Gmg Sistemi\)" <luca.gallo@gmgsistemi.it>
Newsgroups: borland.public.interbase.sql
References: <4631c96e@newsgroups.borland.com> <4631d01c@newsgroups.borland.com>
Subject: Re: Subquery and stored procedures
Date: Wed, 2 May 2007 14:29:28 +0200
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 89.118.69.34
Message-ID: <46388430@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1178108976 89.118.69.34 (2 May 2007 05:29:36 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message