SELECT CONCAT ('Camisa de ',C.camisa)
FROM camisas AS C
UNION ALL
SELECT CONCAT ('Pantalon de ', P.pantalon)
FROM pantalones AS P
UNION ALL
SELECT CONCAT ('Calzado ',Ca.calzado)
FROM calzados AS Ca