Doubt
I have two tables hechamados and helchamadosHistoricos
hechamados -> nrMaximoMinutosSolucao and helchamado
helchamadosHistoricos -> nrMinutosUteis and helchamado
I have to add (helchamadosHistoricos -> nrMinutosUteis) and vcerificar if it is greater than nrMaximoMinutosSolucao
Could someone tell how to do this in a simple table?
hechamados -> nrMaximoMinutosSolucao and helchamado
10 01
helchamadosHistoricos -> nrMinutosUteis and helchamado
2 01
8 01
5 01
Soma (helchamadosHistoricos -> nrMinutosUteis) = 15> that hechamados -> 10 nrMaximoMinutosSolucao then he ACCOUNT