ph [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 10:33 AM
To: Mike Hillyer; [EMAIL PROTECTED]
Subject: RE: Count on Multiple Tables
CREATE TABLE `affiliate_clickthroughs` (
`affiliate_clickthrough_id` int(11) NOT NULL auto_increment,
`affiliate_id` int(11) NOT NULL default '0
ng_status` int(5) NOT NULL default '0',
`payment_date` datetime NOT NULL default '-00-00 00:00:00',
`commission_percent` decimal(4,2) NOT NULL default '0.00',
PRIMARY KEY (`affiliate_orders_id`)
) TYPE=MyISAM;
-Original Message-
From: Mike Hillyer [mailto:[EMAI
Can you show some table structure so we have something work with? It's
hard to recommend a query when we do not know what your sales table
structure is.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Ralph [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 4:00 PM