SELECT CONCAT ('Camisa de ',C.camisa, ' con pantalon de ',P.pantalon)
FROM camisas AS C, pantalones AS P
WHERE NOT (C.Id_camisa = P.Id_pantalon )