I have TableA with 'userid' and 'code'
I have TableB with 'userid' and other fields (but not the 'code' field)
I want to delete TableA & TableB records WHERE A.userid = B.userid and A.code="del".
Is it possible to do this in one MySQL statement and how? (I can't find the answer in MySQL documentation.)
Thank you,
Mickey