Re: multiple PK with a non UNIQUE field

> if you need a multi column fk don't use the "references" keyword on your create table, instead use the "FOREIGN KEY"
> keyword for the table, see the "create table" help.
>
> so for example (untested) change
>
> CREATE TABLE appalto (
> cod_op int not null references Opere,
> cod_com int not null references Opere,
> scadenza date not null,
> importo int not null,
> PRIMARY KEY (cod_op,cod_com)
> );
>
> to
> CREATE TABLE appalto (
> cod_op int not null,
> cod_com int not null,
> scadenza date not null,
> importo int not null,
> PRIMARY KEY (cod_op,cod_com),
> FOREIGN KEY (cod_op,cod_com) REFERENCES Opere(cod_op,cod_com)
> );
>

In this way it works, thanks.