Re: Creating Trigger Using two Tables

[Peter Brawley]

You're vague on join criteria, but is this what you mean?

insert into table1
select table2.*
from table2 a
left join table1 b using (service,numbers,prefer)
where a.ops='A' and b.service is null;

delete table2
from table2 a
join table1 b using(service,numbers,prefer)
where a.ops='D';

PB