How do I delete the content of 1 Table but look at 2 Tables

[WorldNews]

Hello,

How do I delete the content of 1 Table but look at 2 Tables to generate the list of rows that should be deleted.
For example, say this is the SELECT command:

select user_id, advertising_amount FROM users, payments
WHERE users.id = payments.user_id
AND click = 'yes'
AND vs_respmessage = 'Deducted';

How do I then DELETE the resulting ROWS which belong to one of these Tables. That is I need to look at the Table users and Table payments, but DELETE from Table payments only.

Regards,

[Mez]

DELETE p
FROM users u, payments p
WHERE u.id = p.user_id
AND click = 'yes'
AND vs_respmessage = 'Deducted';

[WorldNews]

This works fine.
Thank you

DELETE p
FROM users u, payments p
WHERE u.id = p.user_id
AND click = 'yes'
AND vs_respmessage = 'Deducted';