Hi there folks

I am a novice with SQL and can't figure out how to delete records in my MYSQL database.

I use this code to select the records without any problems but don't know how I can then delete these same records from the database.

SELECT *
FROM `amember_members` , `amember_payments`
WHERE amember_members.member_id = amember_payments.member_id
AND amember_members.status = '0'

When I change SELECT to DELETE it comes up with an error message.

I am doing this in MYPHP and am using version 5

Thanks in advance