select * from table1 where field1 is null

create procedure NEW_PROCEDURE
as
declare variable ID integer;
/*Здесь дообъявляй  :PERSON_ID, :KLADR_ID, :HOUSE, :SECTION, :APARTMENT эти переменные*/
begin
   for select ID, PERSON_ID, KLADR_ID, HOUSE, SECTION, APARTMENT
      from H02_PERSADDRESSES
      into :ID, :PERSON_ID, :KLADR_ID, :HOUSE, :SECTION, :APARTMENT
  do
  begin
    update H02_PERSADDRESSES
    set INVAL_DATE = (select min(INVAL_DATE)
                      from BADADRES
                      where :PERSON_ID = BADADRES.ID_PERSON and
                            :KLADR_ID = BADADRES.KLADR_ID and
                            :HOUSE = BADADRES.HOUSE and
                            :SECTION = BADADRES.SECTION and
                            :APARTMENT = BADADRES.APARTMENT),
        INVAL_REASON = (select min(INVAL_REASON)
                        from BADADRES
                        where :PERSON_ID = BADADRES.ID_PERSON and
                              :KLADR_ID = BADADRES.KLADR_ID and
                              :HOUSE = BADADRES.HOUSE and
                              :SECTION = BADADRES.SECTION and
                              :APARTMENT = BADADRES.APARTMENT)
    where ID = :ID;
  end
end;

SQLEXEC(SQLCONNECT('Connect1'),"execute procedure NEW_PROCEDURE()")