Hi

I would like to create a trigger(Before Insert) on table A,
that will select a date in table B. And if the date in table A
is bigger than the date in B, disallow the current insert into A.

Can anyone please help me with the syntax.

The body should be something like:

begin
select BDate from B where B.cd = new.cd;
if (B.BDate <= new.ADate) CANCELINSERT
end

Regards
Alfred Thomas