On Fri, Jun 11, 2004 at 15:12:36 +0530,
sathish <sathish@ceedees.com> 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.