Re: sql select

Article View: borland.public.interbase.sql

Article #904

Back to borland.public.interbase.sql Previous Next

#904

From: Wayne Niddery [TeamB]
Date: Sat, 14 Apr 2007 16:14

17 lines
1620 bytes

Aaron Masser wrote:
> Is there a way to use a select value as a value of a parameter in the
> same query?  For instance,
> select date, time, hours
> from hours
> where date = date
>
> date being the hours from the select line.

I'm sure it will let you do this, but to what end? The where condition would 
*always* be true and all records would be selected.

-- 
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"Some see private enterprise as a predatory target to be shot, others
as a cow to be milked, but few are those who see it as a sturdy horse
pulling the wagon." - Winston Churchill

Technical Details

Message-ID: <4620fdfa$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed.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: <461fef25$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,4019eac8a25fc334
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
Newsgroups: borland.public.interbase.sql
References: <461fef25$1@newsgroups.borland.com>
Subject: Re: sql select
Date: Sat, 14 Apr 2007 12:14:48 -0400
Lines: 19
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: 69.17.170.228
Message-ID: <4620fdfa$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1176567290 69.17.170.228 (14 Apr 2007 09:14:50 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed.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