1
I need to make an appointment to list calls that haven’t been validated. It works that way:
A call is a support request, in which several actions occur, and all are recorded in an auxiliary table.
I need to filter every call that nay had code action 140 registered, for example.
My appointment was like this:
select chamados from tb_chamados
inner join tb_acoes on tb_acoes.cod_chamado = tb_chamados.cod_chamado
where tb_acoes.acao <> 140
The problem is that the result of this query only ignores the records where the action is equal to 140 and brings the others.
But I want the query to bring me the calls where inside his stock records there is no code 140.