Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!nntp.club.cc.cmu.edu!micro-heart-of-gold.mit.edu!bloom-beacon.mit.edu!bloom-beacon.mit.edu!panix!not-for-mail
From: ruben safir <ruben@mrbrklyn.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Foreign Keys
Date: Fri, 12 Dec 2014 02:23:54 -0500
Organization: PANIX Public Access Internet and UNIX, NYC
Lines: 23
Message-ID: <m6e564$kvh$1@reader1.panix.com>
References: <m4vm6i$hja$2@reader1.panix.com> <701d15b8-5f48-41d8-bc58-99a05b162f27@googlegroups.com>
NNTP-Posting-Host: 96.57.23.82
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 7bit
X-Trace: reader1.panix.com 1418369028 21489 96.57.23.82 (12 Dec 2014 07:23:48 GMT)
X-Complaints-To: abuse@panix.com
NNTP-Posting-Date: Fri, 12 Dec 2014 07:23:48 +0000 (UTC)
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.2.0
In-Reply-To: <701d15b8-5f48-41d8-bc58-99a05b162f27@googlegroups.com>
Xref: csiph.com comp.databases.oracle.misc:889


> 
> 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