Request to collect statistics from 3 tables

Question

MySQL

Good afternoon! I'll start right away, there is a table with a description of the DATA data

ID	NAME	TypeID
one	Brick	one
2	Tile	one
3	Table	2

and two statistics tables for registered users (StatUser)

ID	DATAID	DATE	USERID
one	one	04.05.2012	2
2	one	04.05.2012	3
3	2	05.05.2012	4

and for guests (StatGues)

ID	DATAID	DATE	Gues
one	one	05/06/2012	here cookies
2	one	04.05.2012	here cookies
3	2	05.05.2012	here cookies

It is necessary to write a query that displays the number of visited data by day for different types of accounts and with the ability to summarize data from both statistics tables. I was only able to do from one table:

SELECT 
    DATE_FORMAT(StatUser.Date, '%d-%m-%Y') as Date,
    COUNT(IF(Data.TypeID=1,1,NULL)) as TypeID1View,
    COUNT(IF(Data.TypeID=2,1,NULL)) as TypeID2View
FROM
    Data
INNER JOIN StatUser ON StatUser.DataID  = Data.ID
WHERE
    StatUser.Date > DATE_ADD(NOW(), INTERVAL -7 DAY)
GROUP BY Date
ORDER BY Date

Here it is necessary to somehow include a table with guests ... Help :)

Answer 1

UNION is right for you? :)