On Monday 16 February 2004 18:27, Mulugeta Maru wrote:
> Many thanks. What I would also like to know is that can a field in Table A
> be a foreign key of on of the fields in Table B with has two fields
> combined as a primary key?
Yes, it's possible.
Note: column must be first column in the multi
"Mulugeta Maru" <[EMAIL PROTECTED]> wrote:
> Can a field in one table be a foreign key of another table's field which is
> also a foreign key of a third table?
>
Sure.
For example:
mysql> CREATE TABLE t1 (
-> id int NOT NULL default '0',
-> PRIMARY KEY (id)
-> ) TYPE=InnoDB;
Qu
Can a field in one table be a foreign key of another table's field which is
also a foreign key of a third table?
Maru
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
