05-04-2009, 10:33 AM
|
#5 (permalink)
|
|
The Acquainted
Join Date: Nov 2007
Location: Netherlands
Posts: 113
Thanks: 11
|
Thank you Salathe, this works:
Code:
SELECT datax + datay AS data, viewsx + viewsy as views FROM
(SELECT COUNT(*) AS datax, COALESCE(SUM(views), 0) as viewsx FROM `data_id_custom` WHERE `user_id` = 1) as x,
(SELECT COUNT(*) AS datay, COALESCE(SUM(views), 0) as viewsy FROM `data_id` WHERE `user_id` = 1) as y
|
|
|
|