来自2个不同表的Count（）

Question

I have 2 different tables admin_reservations and calendar_events

admin_reservation:

id,

full_name,

reservation_date,

reservation_time

---

John 03.05.2011 17:00

Mary 03.06.2011 12:00

---

calendar_events:

id,

username,

reservation_date,

reservation_time

---

john.boy 02.05.2011 15:00

suzie 03.05.2011 07:00

---

I want to count like this:

03.05.2011 2

02.06.2011 1

03.06.2011 1

Answer 1

I don't have much time, but I wanna share this:

Do a (select all on table A UNION select all on table B) GOUP BY date.

MySQL UNION

MySQL GROUP BY

Be careful though. This can't be fast =)