Re: Constraint

From: mike <hillmw_at_charter.net>
Date: 24 Mar 2005 12:01:13 -0800
Message-ID: <1111694473.350281.69640@o13g2000cwo.googlegroups.com>

I guess I should be using a check constraint. Let me try. How about:

ALTER TABLE table_A

        ADD CONSTRAINT ck_fk_id CHECK
       ( table_A_id in select table_B.id from table_B, table_C where

table_B.id=table_C.id and table_C.level='0' )

Sound better? Received on Thu Mar 24 2005 - 14:01:13 CST