SELECT u.id, u.nombre, u.apellido, c.campo FROM usuario AS u INNER JOIN campos AS c ON u.idcampo = c.idcampo .