🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #11235

Re: View based on a UNION of 2 Select's

#11235
From: Ivan Prenosil
Date: Thu, 12 Dec 2002 13:39
14 lines
1416 bytes
>   My problem happens when I try to run the following
> select :
...
>
>   The select return the records I want but my plan analyser tool goes crazy
> and show a lot of unrecognized characters instead of the correct plan. Am I
> doing something wrong ? Can I trust that my select will always work ?

Is not the problem with your "plan analyser tool" ?
Have you tried standard plain ISQL ?

--
Ivan
http://www.volny.cz/iprenosil/interbase
Technical Details
Message-ID: <3df89366@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!uunet!dca.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <3df76de6@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,2f86d9a520aeb76b
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-12 05:50:09 PST
From: "Ivan Prenosil" <prenosil@ms.anet.cz>
Newsgroups: borland.public.interbase.sql
References: <3df76de6@newsgroups.borland.com>
Subject: Re: View based on a UNION of 2 Select's
Date: Thu, 12 Dec 2002 14:39:31 +0100
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 194.108.237.247
Message-ID: <3df89366@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039700838 194.108.237.247 (12 Dec 2002 05:47:18 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!uunet!dca.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail