re Composite Primary key..?

From: dave <dmusicman_at_sympatico.ca>
Date: Thu, 12 Jun 2003 08:54:07 -0700
Message-ID: <dB_Fa.10649$Gm4.1032228@news20.bellglobal.com>

Ok i have tried Alter table add Primary key(bla bla bla ) and ran through several permuitations..

Really what i am trying to figure out Is when reconsiling a M:N relationship through

creating a composite entity..... ie composite "contains" the two primary keys of

related entities.... soooo In creating my composite i try...

     Create Table CheckOut(VID_NUM NUMBER(8)
                        CONSTRAINT CheckOut_VID_NUM_FK
                        REFERENCES ForRent(VID_NUM),
                        CUS_NUM NUMBER(8)
                        CONSTRAINT CheckOut_CUS_NUM_FK
                        REFERENCES VCustomer(CUS_NUM));
                        TRANS_DATE DATE  NOT NULL);

But I am not getting how to "Build " the composites primary key from the two foreign keys..

Thx very much for your prompt reply .... thx in advance for another :}

Motivated Rookie D.Moore Received on Thu Jun 12 2003 - 10:54:07 CDT