RE: Count on Multiple Tables

2003-06-06 Thread Mike Hillyer
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&#

RE: Count on Multiple Tables

2003-06-06 Thread Ralph
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

RE: Count on Multiple Tables

2003-06-06 Thread Mike Hillyer
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