Create table with primary key using two foreign keys

I have two tables:
Table1
idproduct (PK)
des_product

Table2
idclient (PK)
des_client

I need create a table like this:
Table3
idproduct (FK)(PK)
idclient (FK)(PK)
des_anything

So, what is the code sql for create this new table?
Thanks.

 

Yes, you can do it. It's called a composite key.

http://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html

 

You can do composite indexes, but that is not what the user wants. The user's requirement cannot be met, because MySQL allows only one primary key per table, and this must have the name PRIMARY. It is impossible to have two primary keys. That's one reason for that it is called "primary", because if you had two, one could not be primary, but secondary to primary.

 

Based on his table design, Table3 doesn't require a primary key other than the composite one.

I can make a table:

CREATE TABLE Table3 (
idproduct INT,
idclient INT, PRIMARYKEY(idproduct, idclient ))

And then add foreign key constraints on idproduct and idclient. This would act as a reference for N:M relationships between Table1 and Table2.