create table test.goods (id int not null primary key,name varchar(10));
insert into test.sale_goods values (0,'Молоко'),(1,'Кефир'),(2,'Пиво');
drop table test.sale_goods;
create table test.sale_goods (id int not null primary key,gid int, QTY INT,sale_date timestamp not null default current timestamp);
insert into test.sale_goods (id,gid,qty) values (0,0,1),(1,1,1),(2,2,1);
insert into test.sale_goods (id,gid,qty) values (3,0,1),(4,1,1),(5,2,1);
insert into test.sale_goods (id,gid,qty) values (6,0,1),(7,1,1),(8,2,1);


select * from test.SALE_GOODS a inner join test.GOODS b on a.gid=b.id;
WITH A AS (
select * from OLD TABLE (delete from test.sale_goods where gid=0) t)
, b as  (
select * from OLD TABLE (delete from test.goods where id=0) p)
select * from a inner join b on a.gid=b.id;
commit;
select * from test.SALE_GOODS a inner join test.GOODS b on a.gid=b.id;