Jump to content

Leaderboard


Popular Content

Showing content with the highest reputation on 05/27/2014 in all areas

  1. 2 points
    Yuri, veja se te ajuda. Você acrescenta outros campos caso necessite. Tabela PFFINANC - Ficha financeira. PEVENTO - Tabela de evento, PFUNC- Tabela de funcionários. select PFFINANC.CODCOLIGADA, PFFINANC.CHAPA, pfunc.NOME, PFFINANC.ANOCOMP, PFFINANC.MESCOMP, PFFINANC.NROPERIODO, PFFINANC.CODEVENTO, PEVENTO.DESCRICAO, PEVENTO.PROVDESCBASE, PFFINANC.HORA, PFFINANC.REF, PFFINANC.VALOR from PFFINANC (nolock) inner join PEVENTO (nolock) on PEVENTO.CODCOLIGADA = PFFINANC.CODCOLIGADA and PEVENTO.CODIGO = PFFINANC.CODEVENTO inner join PFUNC on pfunc.CODCOLIGADA = PFFINANC.CODCOLIGADA and PFUNC.CHAPA = PFFINANC.CHAPA order by ANOCOMP, MESCOMP, NROPERIODO, PFFINANC.CHAPA, PFFINANC.CODEVENTO
  2. 1 point
    Yuri, Não sou especialista no labore mas penso que é esta ligação mesmo.
This leaderboard is set to Sao Paulo/GMT-03:00
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.