Hi All!

I'm having some problems. I have this SP that inserts many rows in a table like this:

INSERT INTO tblMyTable(one_id, two_id)
SELECT p.one_id, m.two_id FROM tblPlayer p, tblMatch m WHERE p.myid = m.nHome OR p.myid = m.nAway

I want it to ignore (skip and continue) this error: Violation of UNIQUE KEY constraint

The unique-key constraint is on the one_id and two_id columns.

Is there anyway to do this? If there isn't, How can I rewrite my Query?