select sum(postageCost) as totalPostage
from tblClientDailes cd inner join tblClients c on c.clientName =
cd.clientName
where cd.dailliesDate between '#date1#' and '#date2#'
and c.acctStatus = 'A'
and cd.clientName like '%marsh%'
group by c.clientName
</cfquery>
And you should really use <cfqueryparam>!!!
> -----Original Message-----
> From: hammerin hankster [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 28 mei 2004 17:31
> To: CF-Talk
> Subject: Re: SUM column data
>
> Okay, I'm being dense about this. I'm getting a syntax error
> when I try this code:
>
> <cfquery name="test" datasource="esitest"> select
> sum(postageCost) as totalPostage from tblClientDailes,
> tblclients inner join tblClients on tblclients.clientName =
> tblclientdailies.clientName where cd.dailliesDate between
> '#date1#' and '#date2#'
> and tblclients.acctStatus = 'A'
> and tblclientdailies.clientName like '%marsh%'
> group by c.clientName
>
> </cfquery>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
