Here's my code:

Code:
CREATE TABLE SALARY
	(
	JOB_ID INT NOT NULL,
	MP_ID INT NOT NULL,
	SALARY_AMOUNT MONEY,
	CONSTRAINT pk_SALARY
	PRIMARY KEY (JOB_ID, MP_ID),
	FOREIGN KEY (JOB_ID, MP_ID) REFERENCES JOB JOIN MP ON UPDATE CASCADE
	);
So the both PKs and FKs come from 2 different tables, everything is working until the foreign key, the part where we have to reference....