I have a table in SQL that contains 2 primary keys of other tables how can i write its script on sql command line

Question

The table named
Tarifer(NUMOUVR,DATEDEB,PRICE)
NUMOUVR and DATEDEB are the two primary keys
But they already exists on other tables
OUVRAGE( primary key is NUMOUVR )
CATALOGUE( primary key is DATEDEB)
CAN U HELP ME PLZ

Answer 1

Use join command

Answer 2

I used alter table foreign key but it shows me error 3780