Error when deleting data

When I use the following sql code it returns 438 records.

SELECT *
FROM amember_members , amember_payments
WHERE amember_members.member_id = amember_payments.member_id
AND amember_members.country = ‘ZA’
AND amember_payments.expire_date = ‘2011-05-11’

I want to delete these 438 records and tried to use this code.

DELETE *
FROM amember_members , amember_payments
WHERE amember_members.member_id = amember_payments.member_id
AND amember_members.country = ‘ZA’
AND amember_payments.expire_date = ‘2011-05-11’

However when I use the sql code above I receive the following error message.

Error
SQL query:

DELETE * FROM amember_members ,
amember_payments WHERE amember_members.member_id = amember_payments.member_id AND amember_members.country = ‘ZA’ AND amember_payments.expire_date = ‘2011-05-11’

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘*
FROM amember_members , amember_payments
WHERE amember_members.member_’ at line 1

What code do I need to use to delete these 438 records?

Thanks in advance.

Thanks very much.

Brenden

Error
SQL query:

DELETE FROM amember_members WHERE amember_members.country = ‘ZA’ AND amember_members.member_id IN (

SELECT amember_payments.member_id
FROM amember_payments
WHERE amember_payments.expire_date = ‘2011-05-11’
MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 6


DELETE FROM `amember_members` 
WHERE amember_members.country = 'ZA' 
AND amember_members.member_id IN
  (SELECT amember_payments.member_id 
   FROM `amember_payments`
   WHERE amember_payments.expire_date = '2011-05-11'
  )

Error
SQL query:

DELETE FROM amember_members ,
amember_payments WHERE amember_members.member_id = amember_payments.member_id AND amember_members.country = ‘ZA’ AND amember_payments.expire_date = ‘2011-05-11’

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE amember_members.member_id = amember_payments.member_id
AND amember_member’ at line 3

Eliminate the *, it should be ‘DELETE FROM’