1 2 3
delete from session as s inner join temporary as t on s.session=t.session where s.session='чему-то'