I have my table called PATIENTS where the primary key is a combination of DOC_NUM and DOB (FECHA_NACIMIENTO) but on my SELECT insert portion a violation to the primary key ocurrs which is fine. If i execute the statment like it is it fails and nothing gets stored on my table. What i need is for those records that the statement finds a match on my table then just skip it and stored the ones that are not present on my table.
HOw can i do this?
INSERT INTO PATIENTS