select vacid AS idvacname AS namevactype AS typevactarget AS targetvaceffect AS effectvacadv_reactions AS adv_reactionsvacproducer AS producervaccreate_time AS create_timevatname AS vaccine_typevatrem

SELECT vac.id AS id,vac.name AS name,vac.type AS type,vac.target AS target,vac.effect AS effect,vac.adv_reactions AS adv_reactions,vac.producer AS producer,vac.create_time AS create_time,vat.name AS vaccine_type,vat.remark AS vaccine_remark,vat.status AS status FROM vaccinum vac JOIN vaccinum_type vat ON vat.id = vac.type JOIN appointment_vaccinum av ON av.vaccinum_id = vac.id