fmerge

CREATE TABLE
ffa


SELECT
vo.misto_id,
vo.misto_nazev,
vo.vekova_skupina,
vr.povolani,
vo.h_total as ock_total,
vo.w_total / vo.h_total as ock_lasweek_pomer,
vr.h_total as reg_total,
vr.h_pocet_rezervace,
vr.w_total / vr.h_total as reg_lastweek_pomer,
vr.h_pomer_registrace,
vr.w_pomer_registrace,
vr.h_wait_time,
vr.w_wait_time




FROM `vo`
JOIN vr ON  vr.misto_id = vo.misto_id AND vo.vekova_skupina = vr.vekova_skupina