Delete record from database

Question

I’m trying to run the following line:

 $sqld = "delete FROM ata where convocatoria.nome_entidade='$ent'   and convocatoria.cod_convocatoria=ata.cod_convocatoria";
 mysql_query($sqld);

I tried direct on phpmyadmin and gave the following error:

Unknown column 'convocatoria.entity' in 'Where clause'

run out:

$sqld = "select * FROM ata,convocatoria where convocatoria.nome_entidade='Spa'     and convocatoria.cod_convocatoria=ata.cod_convocatoria ";
mysql_query($sqld);

It works but it does select * from convocatoria, the problem in delete must be there.

Table call:

Table minutes:

Answer 1

I searched the phpMyAdmin manual and found the solution:

DELETE ata, convocatoria FROM ata INNER JOIN convocatoria 
WHERE convocatoria.nome_entidade='sdasd' 
  AND convocatoria.cod_convocatoria=ata.cod_convocatoria