Results 1 to 3 of 3
Jan 5, 2009, 14:53 #1
How do I delete the content of 1 Table but look at 2 Tables
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:
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.
Jan 5, 2009, 15:38 #2Code:
DELETE p FROM users u, payments p WHERE u.id = p.user_id AND click = 'yes' AND vs_respmessage = 'Deducted';
Jan 5, 2009, 21:10 #3