Okay before I SELECT tables using join.
Now I want to delete it.
Am I still going to use JOIN to delete the record the way I did with the SELECT JOIN.
If yes, then can you show me sample on how to delete records using JOIN.
By the way I'm using MyISAM because my hosting don't support InnoDB.
But can you show me sample of delete with JOIN with MyISAM and InnoDB.
Thanks in advanced.
ON comments.userid = users.id
WHERE users.postcount = 0
AND users.joindate < CURRENT_DATE - INTERVAL 1 YEAR