Re: Can a foreign key in a table reference another foreign key?

Venu wrote:

> hi,
>
> am a little new to database concepts - here's my doubt:
>
> Can a foreign key in a table reference a foreign key in another table
> which is
> referring a primary key in the third table?
>
> T1 (foreign key of )-->T2(foriegn key of) ---->T1 (prim key)
>
> Please help! this is so confusing :) would grealty appreciate if you
> replied directly to homepalmnospam_at_hotmail.com (remove the nospam)
>
> thank you!
>

Why not have T1 (fk) point to T1 (pk).
In the scott demo tables, in emp table mgr column could have a fk on empno (can have a manager that isnt an employee). /Svend Received on Mon Mar 25 2002 - 02:02:26 CST