INSERT WHERE NOT EXISTS syntax

[roger.maynard]

Can anyone tell me why this isn't working... v5.0

 

INSERT INTO master_comments (comment_no,comment_text,language_id)

SELECT comment_no,comment_text,language_id from mComments

WHERE NOT EXISTS (SELECT comment_no FROM master_comments);

 

I thought I had it working once but now it isn't?

 

Roger