Error using DELETE with INNER JOIN in MYSQL

Asked

Viewed 30 times

0

DELETE tbl_grupo_id FROM gc_art_test.tbl_grupo_tbl_permission
INNER JOIN gc_art_test.tbl_grupos
ON tbl_grupo_tbl_permission.tbl_grupo_id = tbl_grupos.id
WHERE tbl_grupo_tbl_permission.tbl_grupo_id = 2246

Error Presented:

SQL error (1109): Unknown table 'tbl_grupo_id' in MULTI DELETE

mysql database
  • 1

    need to give correct aliases for tables, for example DELETE p FROM gc_art_test.tbl_grupo_tbl_permission AS p and so on

  • Dear thank you, that was it... I had even put but I got the syntax wrong..... Thank you

No answers

Browser other questions tagged mysql database

You are not signed in. Login or sign up in order to post.