Description:
when i run the follow sql at my VB program, it will give me wrong result
of the sum(Cost) = 800000
select sum(Cost),sum(Weekly_IMPS),sum(Estimated_Clicks),sum(Estimated_Conversions) from
Online_Plan_Detail a,Site_SYS b where a.Site_Auto_ID=b.ID and b.Site_Level='Standard
Externals' and Plan_ID=1 and Week_Date Between '2008-03-24' and '2008-03-30'
i execute the sql use adodb, adodb version is 2.8.
table detail as follow:
CREATE TABLE online_plan_detail (
ID int(11) NOT NULL auto_increment,
Plan_ID int(11) NOT NULL default '0',
Placement_ID int(11) default NULL,
Site_Auto_ID int(11) NOT NULL,
Creative_Size_ID varchar(10) NOT NULL,
Weekly_IMPS int(11) NOT N
