Hello Group

They want me to transfer the rows from the temporary table cisstudemo to the permanent table studemo. Is this the best SQL statement for that. I am having problems with the constraints on the ident field and others.

INSERT INTO studemo
SELECT * FROM cisstudemo
WHERE ident not in (SELECT ident FROM studemo)

Thanks
Jim