Quick mysql db question for the experts out there. I have two mysql tabes: Table1 ID username Table2 ID username email How can I find all the records that have a certain "email" address in table 2 and then delete those records from both table 1 and table 2?
delete from table1,table2 where email.table2 = 'emailaddress' & username.table1=username.table2 something like that