I have table with attributes ticket number and category. I need to insert data from this table into another table with ticket number as primary key.
What I need is if table 1 contains two entry for same ticket number, than I have to update the second table.
How do I go about doing this?