Re: Selecting several columns using DISTINCT

2002-02-04 Thread Michael Collins
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,

Re: Selecting several columns using DISTINCT

2002-02-03 Thread Joseph Bueno
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. I realize I cannot do a subselect, but in effect > what I am wanting to do is to select the Distinct rows for t