From: pgsql-sql-owner(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Campbell, Lance
Sent: Tuesday, July 09, 2013 3:25 PM
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] delete where not in another table
DELETE FROM T1 WHERE T1.user_id NOT IN (SELECT user_id FROM T2 WHERE T2.user_id=T1.user_id);
Thanks,
Lance Campbell
Software Architect
Web Services at Public Affairs
217-333-0382
--
Try:
DELETE FROM t1
USING t2
WHERE t1.user_id != t2.user_id;
Test it before running on production db.
Regards,
Igor Neyman