Compound Primary Key syntax

[clsyorkshire]

Hi,

I'm writing a query in SQL to create a table - what's the correct syntax for making a compound primary key from two fields?


Regards


clsyorkshire.

 

[glalsop]

Try:

PRIMARY KEY (field1,field2)


-Gary