XPost: comp.databases.oracle.server   
   From: gusz1@freemail.hu   
      
   I would like to do this so that the structure of the tables remain the same.   
   (Since in the real-life analogue of this example it is important that the   
   structures reflect the real-life concepts.)   
      
   Anyway, the question is rather about the implementation of more complicated   
   constraints on tables than this specific example (which actually led me to   
   pose this question in the newsgroup).   
      
      
   "wario"  wrote in message   
   news:962c6d85.0409280619.395fb2@posting.google.com...   
   > --Table A(AID, BID ref. B.BID, CID ref. C.CID, ATXT)   
   > --Table B(BID, CID ref. C.CID)   
   > --Table C(CID)   
   >   
   > 1.  Add CID key to table A.   
   > 2.  Create unique index on CID and ATXT.   
   >   
   > Wario   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)