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?
You can't. If any occurrence of e.g. "John" in staff_skills refers to the same person then you should have a separate "person" table to hold their details.
Your staff_xxx tables can then reference table "person".
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
