Hi,
I am migrating data from one data structure to another and having problems writing a correct INSERT INTO blah SELECT ... from existing tables
I have contact, my addresses (each contact can have several addresses) and address (each address can have several contacts).
I am getting unique key address_id errors despite using a DISTINCT ON
clause in my SELECT so I am doing something wrong
Copies of the queries in question please. Also, cut the INSERT INTO off the front and have a look for any duplicates.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
