I have used to write like these, how these must be modified for the Firebird

deleting from one table according to relation with another table
------------
delete s from tmp_s s,delivery t
where s.id=t.id and s.id_part=t.id_part and s.id_row=t.id_row
------------

updating fields using relation with another table
------------
update s set delivWeek=DeliveryWeek,delivYear=DeliveryYear
from tmp_s s,order t
where s.id=t.id and s.id_part=t.id_part
------------

Could someone post FAQ -address

Basics are easy, now I want to do something...