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=1 and orc.data between '2026-04-20' and '2026-04-22' and orc.situacao='F' order by ve.nome                                                    /*ordem*/                                                    