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 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