<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]
