my table
create table coursedept (did (pk,fk,varchar(50),notnull,
(cid (pk,fk,varchar(50),notnull) )
how to add pk and fk for same column
ive already created did(department table ) and cid(course table) with primary key i need to combined these two table
coursedept(did ,cid)
pls help me how to do it