>Will this accomplish my goal?
Don't know. What is your goal?
>DELETE FROM conphone WHERE conuniq in (SELECT conuniq FROM cisconphone) and phnnumber in (SELECT phnnumber FROM cisconphone).
WATCH THIS!!!! This will delete all the rows in conphone where conuniq is stored in any row in cisconphone AND phnnumber is stored in any row in cisconphone AND THERE IS NO REQUIRED THAT IT IS THE SAME ROW.
Is this what you want?
-Mike
>
>Will this accomplish my goal?
>
>INSERT INTO conphone
>SELECT * FROM cisconphone
>WHERE conuniq not in (
> SELECT conuniq
> FROM cisconphone
> GROUP BY conuniq
> HAVING (COUNT(conuniq) > 1)
> )
>AND
>
>phnnumber not in
> (
> SELECT phnnumber
> FROM cisconphone
> GROUP BY phnnumber
> HAVING (COUNT(phnnumber) > 1)
> )
>
>
>Thanks
>Jim