SQL INSERT / SELECT不在insert表中

INSERT INTO     `tableA`
SELECT          `Col1`, 
                `Col2`,
                 NOW() 

FROM            `tableB`

WHERE           tableA.Col1 is not already in tableB.Col1
INSERT INTO     `tableA`
SELECT          `Col1`