Thank you for the suggestion. This is the actual query that I implemented: Amazing how this works. Ron
SELECT SUM( `impressions_total` ) AS impressions_total , SUM( `usage_total` ) AS usage_total FROM ( ( SELECT IF ( SUM( `web_advertisements_our_clients_usage`.`impressions` ) , SUM( `web_advertisements_our_clients_usage`.`impressions` ) , 0 ) AS impressions_total, IF ( SUM( `web_advertisements_our_clients_usage`.`usage` ) , SUM( `web_advertisements_our_clients_usage`.`usage` ) , 0 ) AS usage_total FROM `web_advertisements_our_clients_usage` WHERE `web_advertisements_our_clients_reference` = $web_advertisements_our_clients_reference AND `month` = $stats_month AND `year` = $stats_year LIMIT 1 ) UNION ALL ( SELECT `impressions` AS impressions_total, `usage` as usage_total FROM `web_advertisements_our_clients` WHERE `reference` = $web_advertisements_our_clients_reference LIMIT 1 ) ) AS monthly_stats_total; The Verse of the Day “Encouragement from God’s Word” http://www.TheVerseOfTheDay.info
