Re: [ADMIN] doubt

On Fri, Jun 11, 2004 at 15:14:07 +0530,
sathish <sathish(at)ceedees(dot)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.

No. References need to be to keys (columns with a unique index on just
the columns being referenced).

In this case you almost certainly what to have the name table separate
from the skill table and have both the skill table and the other table
refer to the name table.

> 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?
> your immediate reply will be helpful
> yours sincerely
> SathishKumar.S