Mysql Help (Delete/Join)

coolhome

I have this query im trying to make it DELETE rows from a table is a another table row is inactive. Here it is.

DELETE FROM chat_rooms AS c INNER JOIN accounts AS a ON '$time'<a.last WHERE c.talk_to='$uid'

Anyone know how i would do this right :P?


:glasses2: THanks


Crap Wrong category again its under PHP o.O sorry!

LurkinBack

Is there not supposed to be a unique link between the tables or does that not apply in MySQL?