Can anyone give me an example of the required SQL statement that would alter a table that has no primary key to one that has two primary keys. To keep things simple, lets assume that I have a table containing fields X, Y & Z and I would like to make a composite, primary key, using X & Y

Thanks