select distinct a.id, a.razao_social, b.vendedor FROM cliente a, vendedor_cliente b, vendedor c where a.id = b.cliente and b.vendedor = c.id and c.superior = ? order by 2