admin 管理员组

文章数量: 1086019

i have 2 tables:

  • books b1
  • price p1

i want to remove rows from both tables using the following query:

DELETE books FROM price p1 JOIN books b1
ON b1.BOOK_ID = p1.ID WHERE p1.ISBN IS NOT NULL AND p1.VALUTA = 'yen'
AND b1.YEAR BETWEEN 2011 AND 2014

but i get the error:

An unexpected token "price" was found following "books FROM" expected token may include "JOIN"

I think i am following the correct order.

DELETE (choose 1 of the 2 tables)

then FROM(the other table)

followed by JOIN(the first table again)

what am i doing wrong?

本文标签： use SQL to delete rows from 2 table DBeaverStack Overflow

版权声明：本文标题：use SQL to delete rows from 2 table DBeaver - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.roclinux.cn/p/1744027242a2520848.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。