使用两个表中的条件从一个表中删除Mysql

Question

I am using this code/query to delete bogus users using a list from 'bogus' table and Obviously this query is not correct and shows error: Unknown column 'bogus.user' in 'where clause' Consider that tables sample and bogus have ONLY ONE COLUMN each and I want to delete rows from sample table only retaining the data of table bogus.

delete from sample where sample.user=bogus.user;

Answer 1

How about:

 delete from sample where sample.user in (SELECT user FROM bogus);

I think that's the savest way. It's probably possible to put both tables in a single statment without a join or nested select. But If you do that wrong you risk deleting both tables content. Thus I'd say it's better to do it this way.