database - PostgreSQL : how to delete rows of Table1 where category = x (but Category is defined in Table 2)?

Question

我有一个 Postgres 数据库。我正在尝试根据表 2 中表达的条件删除表 1 中的行。

表 1:id, object_id, time, action_type

表 2:object_id, object_name, object_category

我想删除表 1 中的所有行，其中 object_category = x。

Answer 1

您可以将 in 语句与 delete 一起使用:

delete from table1
    where object_id in (select object_id from table2 where table2.object_category = x)