How to create two primary keys

[Shabana123]

Dear Experts,



I have one query which is already stored. Now I need to add one more query and update the same. I need to refer the primary key which is there in the first query and continue doing the operation. Please suggest what is the best method to go about it.

Thanks in advance

[orange]

You are going to have to describe your situation more clearly. Please tell us in plain English WHAT you are trying to accomplish. Post the SQL for your query (ies). Perhaps you could give us some sample data to show the issue?

The title of your post is very misleading. One table --> one primary key. But you can have a compound primary key...