title: Referencing a two column primary key with multiple foreign keys
body: <p>Take the following two tables in Oracle:</p>
  
  <pre><code>Create Table A
  ( A int, B int, C int,
    Constraint pk_ab Primary Key(A, B),
    Unique (C)
  );
  
  Create Table B
  ( D int, E int, F int,
    Constraint fk_d Foreign Key (D) References A(A),
    Constraint fk_e Foreign Key (E) References A(B)
  );
  </code></pre>
  
  <p>Why doesn't this statement work? Or more specifically, why shouldn't it work? The reason I'm trying to create this type of relation is say, in the future, I want to delete <code>B.D</code>, but keep the relation <code>FK_E</code>.</p>
  
  <p>I'm getting the error:</p>
  
  <blockquote>
    <p>ORA-02270: no matching unique or primary key for this column-list</p>
  </blockquote>