DELETE FROM table WHERE condition;
DELETE FROM table USING another_table WHERE table.id = another_table.id;