Re: Populating one table with data from another

2003-01-14 Thread Stefan Hinz, iConnect \(Berlin\)
Michael, > I have a table, products containing a 944 rows. One of the fields is > fgNumber, > I have another table, categoryRelatedToProducts which also has an fgNumber > field and currently has no data. > I'd like to add all 944 fgNumbers to the categoryRelatedToProducts table. INSERT INTO categ

Re: Populating one table with data from another

2003-01-14 Thread Gelu Gogancea
Hi, You can use INSERT...SELECT. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Michael Knauf/Niles" <[EMAIL PRO

Re: Populating one table with data from another

2003-01-14 Thread Steve Edberg
Use INSERT...SELECT syntax: http://www.mysql.com/doc/en/INSERT_SELECT.html -steve At 12:01 PM -0500 1/14/03, Michael Knauf/Niles wrote: Ok, this has got to be easy, but I'm not getting it right... I have a table, products containing a 944 rows. One of the fields is fgNumber, I have another

Re: Populating one table with data from another

2003-01-14 Thread Paul DuBois
At 12:01 -0500 1/14/03, Michael Knauf/Niles wrote: Ok, this has got to be easy, but I'm not getting it right... I have a table, products containing a 944 rows. One of the fields is fgNumber, I have another table, categoryRelatedToProducts which also has an fgNumber field and currently has no da