Erro 1064 => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by tbprofissional.dsnome asc' at line 1

SELECT tbprofissional.idprofissional,tbprofissional.dsapelido,tbprofissional.dsnome,tbcargo.dscargo FROM tbprofissional LEFT JOIN tbcategoria ON (tbprofissional.idcategoria1 = tbcategoria.idcategoria) LEFT JOIN tbcargo ON (tbprofissional.idcargo = tbcargo.idcargo) WHERE tbprofissional.flativo = 'S' and tbcargo.dsarea = 'C' and tbprofissional.idequipe= order by tbprofissional.dsnome asc