This is my query:
(
SELECT `unixtime2` , `pagenum` , count( DISTINCT `ipaddress` ) AS pagenumtotal
FROM `orders1`
WHERE unixtime2 >20081031
AND pagenum != ''
GROUP BY `unixtime2` , `pagenum`
ORDER BY `unixtime2` , pagenum ASC
)
UNION (
SELECT `unixtime2` , `pagenum` , count( DISTINCT `ipaddress` ) AS pagenumtotal
FROM `ordersbp`
WHERE unixtime2 >20081031
AND pagenum != ''
GROUP BY `unixtime2` , `pagenum`
ORDER BY `unixtime2` , pagenum ASC
)
This query yields two separate values for each date and doesn't merge them, a result of the "Count" function. If I were doing a query for just the count alone could use "+" instead of "union" but I need to return values based on the date, pagenum and the unique count of ip addresses for each.
Advice? Thanks so much!