[th_bav]

DELETE FROM bron
WHERE id_razm in (SELECT razm.id_razm FROM razm, bron
WHERE razm.id_razm = bron.id_razm AND zaezd<CURRENT_TIMESTAMP as DATE);

Я пробовал так, не получилось...., или надо было по другому????