MySQL - Delete's and temp tables

[Spijker]

I have a table which stores meeting times and want to remove the most recent double entries where they match the same time,date and place. I have created a temporarary table with the data that matches what I want to remove from the main table but when I run the DELETE queries it won't recognize the tmp tables existance in the query.

Below is the query in question.

DELETE FROM stfrmlink WHERE stfrmlink.ID = xtmp.ID;


rob.spijkerman@alliedtelesyn.co.nz