Re: about primary key

Give example please.

To me this sounds obvious but I'm probably misreading your problem.

EG.
Table Departments(deptno, deptname);
Table Employees(empno, empname, deptno);

deptno is primary key of Departments and Foreign Key to employees.

Presumably this is not what you mean.

Regards

Ray

hpcheong_at_ncs.com.sg wrote in message <710rc0$1io$1_at_nnrp1.dejanews.com>...
>hi all,
>
>can someone tell me whether the same field in a particular table, be a
>primary key as well as a foreign key to another table at the same time??
>
>pls reply ASAP as this is urgent!
>
>thanks in advance!
>
>
>rgds,
>evelyn.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Oct 26 1998 - 01:09:50 CST