[SOLVED] Deleting data from two tables simultaneously

[eluser]Unknown[/eluser]
[quote author="theshiftexchange" date="1295943163"]Ok - I've worked it out using a normal SQL query. I tried to convert it to an active record query but it doesnt work for some reason.

function delete_id ($my_ID_to_delete)
{
return $this->db->query("
DELETE t1.*, t2.*
FROM table1 t1, table2 t2
ON t1.id = t2.id
WHERE t1.id = '".$my_ID_to_delete."'");
}[/quote]