merge two tables with a column in comun

I have two tables

table inscripcion
------------------------------------------------------
|date         |   other fields  |
------------------------------------------------------


table visitas
------------------------------------------------------
|date         |   other fields  |
------------------------------------------------------

When I need the total of records of this tables group by date I use this querys:

SELECT date, COUNT( * ) AS total_inscripcion
FROM inscripcion
GROUP BY date

Select allOpen in new window

SELECT date, COUNT( * ) AS total_visitas
FROM visitas
GROUP BY date

Select allOpen in new window

I would like to make this querys in a single query where I receive something like this:
------------------------------------------------------------------
|date         |   total_inscripcion  |   total_visitas  |
------------------------------------------------------------------
Where date is the merge between the fields date from inscripcion and date from visitas
           total_inscripcion: total of records from inscripcion group by date
           total_visitas: total of records from visitas group by date.

I try this one:

SELECT DISTINCT t1.date, t1.total_inscripcion, t2.total_visitas
FROM (SELECT date, count( * ) AS total_inscripcion FROM inscripcion GROUP BY date)t1
LEFT JOIN (SELECT date, count( * ) AS total_visitas FROM visitas GROUP BY date)t2 ON t1.fecha = t2.date
UNION SELECT DISTINCT t2.date, t1.total_inscripcion, t2.total_visitas
FROM (SELECT date, count( * ) AS total_inscripcion FROM inscripcion GROUP BY date)t1
RIGHT JOIN (SELECT date, count( * ) AS total_visitas FROM visitas GROUP BY date)t2 ON t1.date = t2.date

Select allOpen in new window

I works, but I would like to know if somebody knows if there is a better options to do this query.


best regards