delete from session as inner join temporary as on session session wher

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