mysql - SQL SELECT query, tables with no column in common -

mysql - SQL SELECT query, tables with no column in common -

i'm working 2 databases: relation between 2 tables db1.tab1.model_id=db2.tab2.id_element

delete db1.tab1 db1.tab1.model_id in ( select db1.tab1.model_id db1.tab1 db1.tab1.model_id = db2.tab2.id_element in ( select db2.tab2.id_element db2.tab2 db2.tab2.deleted='1' ) );

i'm not surprised doesn't work since 4th line sucks, thing know can't put

where db1.tab1.model_id in (select db2.tab2.id_element .....)`

i mean where clause should same in select!

can seek query? looking @ query seems want delete records tab1 marked deleted in tab2.

delete db1.tab1 db1.tab1 bring together db2.tab2 on db1.tab1.model_id = db2.tab2.id_element db2.tab2.deleted='1';

mysql sql select delete-row