SQL Query Help: Need to delete from one table based on value in another table
I am trying to delete a set of about 500 members from my Awaiting Email Confirmation group that have a set value for a custom profile i have that is required.
Profile Field is:
Value I want to flag is:
Im using PHPMyAdmin and I have this query so far...
DELETE FROM user WHERE userfield.field13 = 'test'
Im getting this error kicked back:
Unknown column 'field13' in 'where clause'
Im assuming that the error is because im trying to delete from one table while referencing another table and I have it directed incorrectly.
can anyone give me some insight as to how i need to query this correctly in order to delete users in the USER table based on a value set in the FIELD13 row within the USERFIELD table
Thanks a ton!
--------------- Added 14 Jun 2009 at 22:23 ---------------
No members have liked this post.
Last edited by CodeRed : 14 Jun 2009 at 22:23. Reason: Auto-Merged DoublePost
|Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)|
|New To Site?||Need Help?|
All times are GMT. The time now is 07:21.