The easiest way to do that would be to CREATE TABLE new_table_name
SELECT (query you use to join the tables)
The old tables then become redundant.
On 11 Jan 2006, at 17:30, 2wsxdr5 wrote:
I have two tables with data on people in them. Table A is a subset
of table B, However, there is data about these people in table B
that is not in table A. with a simple select I can do a join and
get a result set with all the data I need to show, but what I would
like to do is change table A so it also has one of the fields from
table B. Adding the field to table A is trivial , but how do I
then populate that new field with data from the table B?
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want & give the gifts they want
One stop wish list for any gift, from anywhere, for any occasion!
http://thewishzone.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
