select a.numero,a.cliente,a.nome,a.data,b.descricao,b.qtd,b.valor,b.preco,a.vendedor from fa a inner join faext b on a.numero=b.numero where a.vendedor=2 and convert(datetime,a.data,105) between '12-01-2023' and '12-31-2023'  and a.anulado=0 order by a.numero