On Fri, Jun 11, 2004 at 15:12:36 +0530, sathish <[EMAIL PROTECTED]> wrote: > dear groups, > i have a doubt in sql, > i have a table staff_skills in which i have set a table level > constraint to create a primary key of two fields . > so 'name' and 'skill' combinedly forms a primary key. > now the issue is in another table i have only 'name' field and i > want to create a foreign key constraint which refers the staff_skills > table's 'name' field only. > staff_skills (table) - name,skill,ability (columns) --- primary > key(name,skill) > staff_xxxx (table) - name,x,y,z (columns) --- foreign > key(name) references staff_skills(name). > how to do the above?
This reference is the wrong way. The staff_skills table's name column should reference name in the staff_xxxx table. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
