> > > > Select R.ID,R.Numero,R.Ano,R.Data,R.Processo,R.dtLancamento,R.Status, > S.Descricao Secretaria > >From Secretaria S, Requisicao R > Where (R.ID_Secretaria = 1) And (R.ID_Secretaria = S.ID) and (select * > from departamento where id_departamento = R.Id_departamento) Tenta isso ai ve c resolve. xD