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 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 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. > > Can I do this with one sql statement? > > Michael > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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