Re: Populating one table with data from another

2003-01-14 Thread Stefan Hinz, iConnect \(Berlin\)
esestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Michael Knauf/Niles" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 14, 2003 6:01 PM Subject: Populating one table with data from another &

Re: Populating one table with data from another

2003-01-14 Thread Gelu Gogancea
t; <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 14, 2003 7:01 PM Subject: Populating one table with data from another > > 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 th

Populating one table with data from another

2003-01-14 Thread Michael Knauf/Niles
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 data. I'd like to add all 944 fgNumbers to the categ

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