Delete Records SQL

When you want to delete rows from one table that are not present in another table:

delete from queue_table q where  not  exists ( select 1 from man_table r  where r.trx_id=q.trx_id);