Posted on 2004-10-13
Simplified situation: I have a table that I want to delete entries from based on entries in another table:
My query so far:
DELETE FROM Table1 USING Table2 WHERE Table1.user = Table2.user AND Table2.group = 'something I know';
Not sure if this is the right query, but this is where I am right now. Currently, it's giving me the error:
ERROR 1066: Not unique table/alias: 'Table2'
However, 'Table2' is unique as far as I can see.. no other tables, or fields are named that.