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-02-23' and '2026-02-25' and orc.situacao='F' order by orc.codigo                                                    /*ordem*/                                                    