Re: Foreign Keys
From: ruben safir <ruben_at_mrbrklyn.com>
Date: Fri, 12 Dec 2014 02:23:54 -0500
Message-ID: <m6e564$kvh$1_at_reader1.panix.com>
Date: Fri, 12 Dec 2014 02:23:54 -0500
Message-ID: <m6e564$kvh$1_at_reader1.panix.com>
>
> SQL>
> SQL> ALTER TABLE WORKS_ON ADD CONSTRAINT workson_essn FOREIGN KEY (ESSN)
> 2 REFERENCES EMPLOYEE (SSN);
>
> Table altered.
>
> SQL>
>
> My original assessment still stands -- there is data in the child table that isn't matched in the parent.
>
>
> David Fitzjarrell
>
Thank You David
I appreciate it. I read other people doing and I think to myself, oh I'm not that stupid...
Ruben Received on Fri Dec 12 2014 - 08:23:54 CET