How to create a table (many-to-many association) from the primary keys of tables?

[lionelm2007]

In mysql, I need to create a table to store the many-to-many relationship of the other two tables.

Here is the problem:

the first table has three fields that act as the primary key of the table

the second table has only one field for the primary key

i know the association table will have the primary keys of both tables as its own primary key but it seems that I can't do that. It appears that the three fields primary key in the first table is giving me some trouble!

Is this allowed in MYSQL? If so, could someone please provide a sample sql code.

Thanks.

[Gephiers]

Is this what you want?
CREATE TABLE C
(
AFiled_a INTEGER NOT NULL,
AFiled_b INTEGER NOT NULL,
AFiled_c INTEGER NOT NULL,
BFiled_a INTEGER NOT NULL,
PRIMARY KEY (AFiled_a, AFiled_b, AFiled_c, BFiled_a),
KEY (AFiled_a, AFiled_b, AFiled_c),
KEY (BFiled_a)
)
;


CREATE TABLE B
(
Filed_a INTEGER NOT NULL,
BContent TEXT,
PRIMARY KEY (Filed_a)
)
;


CREATE TABLE A
(
AFiled_a INTEGER NOT NULL,
AFiled_b INTEGER NOT NULL,
AFiled_c INTEGER NOT NULL,
AContent TEXT,
PRIMARY KEY (AFiled_a, AFiled_b, AFiled_c)
)
;





ALTER TABLE C ADD CONSTRAINT FK_C_A
FOREIGN KEY (AFiled_a, AFiled_b, AFiled_c) REFERENCES A (AFiled_a, AFiled_b, AFiled_c)
;

ALTER TABLE C ADD CONSTRAINT FK_C_B
FOREIGN KEY (BFiled_a) REFERENCES B (Filed_a)
;