Hello Everybody!
I´m trying to use delete to remove data from one table based on another. The query is this:
DELETE FROM table1 WHERE column1 IN (SELECT column2 FROM table2);
but my table is big, so it takes a lot o time...
Is there a way to use DELETE with INNER JOIN in PostGreSQL?
Thanks!
Att.
Ricardo Valença
UEAD - UGF