Alexsandro Santos Posted May 21 Topic Count: 22 Topics Per Day: 0.02 Content Count: 38 Content Per Day: 0.03 Reputation: 10 Achievement Points: 411 Solved Content: 0 Days Won: 3 Status: Offline Age: 39 Device: Windows Report Posted May 21 (edited) Olá, pessoal. Será que nessa consulta slq anexa onde gero os abonos dos funcionários é possível, qndo o abono vier de um atestado, se tem como termos a coluna indicando o código dele, descrição e o CID? RM 12.1.2410.229. Abonos.sql Edited May 21 by Alexsandro Santos
caiiomonteiro Posted May 21 Topic Count: 12 Topics Per Day: 0.00 Content Count: 181 Content Per Day: 0.06 Reputation: 87 Achievement Points: 1,182 Solved Content: 0 Days Won: 32 Status: Offline Age: 28 Device: Windows Report Posted May 21 Opa @Alexsandro Santos Acho que um possível teste é fazer um join com a tabela VATESTADO, nela tem o código da pessoa e a data inicial do atestado, que seria a data de referencia do abono e depois você vincula a tabela VCID com a VATESTADO 3
Solution Alexsandro Santos Posted May 21 Topic Count: 22 Topics Per Day: 0.02 Content Count: 38 Content Per Day: 0.03 Reputation: 10 Achievement Points: 411 Solved Content: 0 Days Won: 3 Status: Offline Age: 39 Device: Windows Author Solution Report Posted May 21 @caiiomonteiro obrigado pelo retorno, consegui aqui usando a PFHSTAFT e VCID. VLW. 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now