I have the following query:
update ivr_contatos,ivr_campanha set ivr_contatos.tentativas = 0 where ivr_contatos.status = 0 and ivr_contatos.tentativas >= ivr_campanha.qtdtentativas
The question is, if I can update in the field tries ivr_contatos table using as premise the field status (ivr_contatos) and qtdtentativas (ivr_campanha)
Structure of tables:
The data can not pass because I do not have it yet.