select orc.*, ve.FANTASIA vendedor,                          tra.nome transportador                                       from orcamento orc                                           left join pessoa ve on ve.codigo=orc.fkvendedor              left join transportadora tra on tra.codigo=orc.fk_transp      WHERE orc.fkempresa= and orc.data between '2026-01-05' and '2026-01-10' order by orc.codigo                                                    /*ordem*/                                                    