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
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;
Query OK, 0
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
