Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Foreign key problem

Re: Foreign key problem

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 15 Jun 2006 12:48:15 -0700
Message-ID: <1150400895.187234.182020@y41g2000cwy.googlegroups.com>


>> (a,b) REFERENCES (c,d)

    (b,a) REFERENCES (c,d) <<

Read the SQL Standards:

  (a, b) REFERENCES (c,d)
implies that a MATCHES c AND b MATCHES d

  (b, a) REFERENCES (c,d)
implies that b MATCHES c AND a MATCHES d

these are very different. Received on Thu Jun 15 2006 - 14:48:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US