Re: Adding data from one table to another

2006-01-11 Thread simon elliston ball
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

RE: [SPAM] - Adding data from one table to another - Bayesian Filter detected spam

2006-01-11 Thread Gordon Bruce
from one table to another - Bayesian Filter detected spam 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

Re: Adding data from one table to another

2006-01-11 Thread SGreen
2wsxdr5 [EMAIL PROTECTED] wrote on 01/11/2006 12:30:10 PM: 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