select m.*,c.c_cliente,c.c_uf,f.c_razao,f.c_cgc from a_movime m
left join a_client c on c.c_codigo = substring(m.c_codcf,1,8)
left join a_filial f on f.c_codigo = m.c_fil
where m.c_chave = '$chave'