Some time ago I'm thinking of a solution to my problem and decided to show here ...
Let's see if anyone can help me , come on.
I have 2 two tables:
-CALENDARIO_TRABALHO
-LANCAMENTO_PONTO
In CALENDARIO_TRABALHO table I have all employees with its range of clearances / work follows in annex.
In the LANCAMENTO_PONTO table I have all clocking records , with the date and with the same CPF .
What I need , is that it identifies the CPF DEVELOPER in DATE CALENDARIO_TRABALHO table and try to identify the same date in LANCAMENTO_PONTO table, and add some field "Fault" .
NOTE: In the Calendar table when the date is marked '1' means CLEARANCE IN THE DAY .
