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

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 dat