SELECT CONCAT(`nume`, " ", `prenume`) AS nume, `id_adresa`, "CLIENT" AS Observatii FROM clienti
UNION
SELECT CONCAT(`nume`, " ", `prenume`) AS nume, `id_adresa`, "ANGAJAT" AS Observatii FROM angajati;