Rob Gould wrote:
I've got 2 tables. One table which contains a series of barcodes assigned to
product id #'s, and another table with JUST product id #'s.
I need to somehow transfer all the barcodes from the first table into the
second table, but only where the id #'s match.
Can anyone tell me if this is something that can be done with just a SQL
statement, or do I need to write a PHP script to loop through the records of
both tables and do the copying/mapping?
insert into table (field1, field2) select field1, field2 from t1 inner
join t2 using (field_id);
or something like that.
http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
