Hi all,
I need someone please to advice me of the following sql code
Select TRANS_DATE,TRANSTIME, POSNUMBER, TRANSNUMBER, Count(ITEM_QTY) as
ItemsSold,
SUM(LINE_TOTAL) as LineTotal from accounthistory "
WHERE TRANS_DATE BETWEEN '" & StartDate & "' AND '" & EndDate AND
AccountID='1001'
GRO
Means exactly what it says. You don't have TRANS_DATE and TRANSTIME in
either the GROUP BY or in an aggregate function.
As the query can process many records with different values for these
columns what do you expect the query to return?
On 25/09/2014 14:38, 'Andrew Gable' andrew.ga...@tesco.
'
GROUP BY ItemsSold, LineTotal Order By TRANS_DATE, TRANSTIME DESC;
Is that how I would sort it?
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 25 September 2014 3:09 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Advice with
eds ?
Good luck!
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Thursday, September 25, 2014 5:11 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Advice with the following sql command
Ok so how do I sort it?
Select TRA
-support@yahoogroups.com
Subject: RE: [firebird-support] Advice with the following sql command
Manyou shlould read a bit more before going on this road. It a simple
example of select with group option.
Select TRANS_DATE,TRANSTIME, POSNUMBER, TRANSNUMBER, Count(ITEM_QTY) as
ItemsSold
If a column in a SELECT list is not an aggregate function then you need to
write it in the GROUP BY clause.
Many people have your same problem when start using SQL.
Greetings.
Walter.
On Thu, Sep 25, 2014 at 9:38 AM, 'Andrew Gable' andrew.ga...@tesco.net
[firebird-support] wrote:
>
>
> Hi a