Some possibilities
INSERT INTO foo\nSELECT *\nFROM bar b\nWHERE (b.keyid NOT IN(SELECT f.keyid FROM foo f))INSERT INTO foo\nSELECT *\nFROM bar b\nWHERE NOT EXISTS(SELECT f.keyid FROM foo f WHERE f.keyid = b.keyid)INSERT INTO foo\nSELECT *\nFROM \n bar b\n LEFT OUTER JOIN foo f ON(f.keyid = b.keyid)\nWHERE f.keyid IS NULL