At 4:46 PM +0100 2/3/02, Joseph Bueno wrote: >Michael Collins a écrit : > > I am trying to normalize some MySQL tables and need to move a few >> columns from one table to another while maintaining the relationship > > between the two. > > SELECT DISTINCT ProductID >> >> (SELECT >> ProductID, >> SmImage, >> ProductName, >> Description, >> LgImage > > WHERE ProductID=ProductID) > > FROM productSKU >> > > How do I rewrite this query to get what I am after?
>Have you tried : >SELECT DISTINCT ProductID,SmImage,ProductName,Description,LgImage > FROM productSKU ? > >If all records with same ProductID have also the same values for >other selected fields it should work; otherwise, your normalization >has some problem. > >Regards >-- >Joseph Bueno Unfortunately not, the Description differs. You are correct there is a problem with normalization and that is what I am trying to fix. I need to select the unique row based just on the ProductID column, then move this foreign key to a record in a new table where ProductID becomes the key. At the same time I want to import along with ProductID a few more field values (which I can then remove from the productSKU table). -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
