"VC" <boston103_at_hotmail.com> wrote in message
news:X0ZQb.20613$U%5.162136_at_attbi_s03...
> But, anyway, here's an example for SQL purists:
>
> create table t1(id int, amount int);
> create table t2(id int, amount int);
> insert into t1 values(1, 40);
> insert into t2 values(1, 60);
> commit;
>
> -- two linked account have 100 total. The constraint is that the total
> should not go below zero.
and where is this constraint expressed? I don't see it.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Mon Jan 26 2004 - 11:38:32 CST
