Re: got the following SQL error

Article View: borland.public.interbase.sql

Article #11305

Back to borland.public.interbase.sql Previous Next

#11305

From: Eras
Date: Wed, 27 Nov 2002 11:45

34 lines
1574 bytes

Your SQL must be:

Select Sum(bedrag) , klantnr
From verkoopgeg
Group By klantnr



"paulus" <tcwijck@wxs.nl> wrote in message news:3DE4A780.A5951374@wxs.nl...
> when i type the following sql statement in ib 6.0 .
>
> Select Sum(bedrag) , klantnr
> From verkoopgeg
>
> i get te following error  sql error -104  Invalid column Reference
> (invalid token)
> but when i type the statement as following
>
> select sum(bedrag)
> from verkoopgeg
>
> or
>
> select klantnr
> from verkoopgeg
>
> i get no errors message
>
> the table looks as following
>
> bedrag numeric
> klantnr integer
>
>

Technical Details

Message-ID: <3de4b054@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!ken-transit.news.telstra.net!news.telstra.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3DE4A780.A5951374@wxs.nl>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,51b596a639c4f8ff
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-11-27 03:54:04 PST
From: "Eras" <edgaras.zuklys@one.lt>
Newsgroups: borland.public.interbase.sql
References: <3DE4A780.A5951374@wxs.nl>
Subject: Re: got the following SQL error
Date: Wed, 27 Nov 2002 13:45:13 +0200
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 81.16.230.59
Message-ID: <3de4b054@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1038397524 81.16.230.59 (27 Nov 2002 03:45:24 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!ken-transit.news.telstra.net!news.telstra.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message