' AND
'2003-09-31'
GROUP BY afs.stat_date
Hope that helps.
Matt
- Original Message -
From: Mike Morton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 6:27 PM
Subject: Query not returning 0 count records
In the following query:
select
' AND
'2003-09-31'
GROUP BY afs.stat_date
Hope that helps.
Matt
- Original Message -
From: Mike Morton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 6:27 PM
Subject: Query not returning 0 count records
In the following query:
select
In the following query:
select afs.stat_date,afs.hits,count(v.clientcode) as signups from
affiliate_stats as afs,vtconlineusers as v where affiliate_id='a280' and
afs.stat_date between '2003-01-01' and '2003-09-31' and v.creation_date =
afs.stat_date and v.dealercode=afs.affiliate_id group by
affiliate_id='a280' AND afs.stat_date BETWEEN '2003-01-01' AND
'2003-09-31'
GROUP BY afs.stat_date
Hope that helps.
Matt
- Original Message -
From: Mike Morton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 6:27 PM
Subject: Query not returning 0 count records
