Hi Chris,

I'm no expert but when I have tried to do something similar I have used the 
INSERT INTO  destinationtablename SELECT criteria FROM sourcetablename WHERE
criteria = expression here
This will insert the new data into the #TempTable using an Append type of
query.
The existing data will still be present and the new data 'appended' in
ascending order.
Not sure if this is what you're looking for but maybe it will help...I
hope!!
Good Luck.
Nigel.


> -----Original Message-----
> From:	Chris Browning [SMTP:chris_browning@m...]
> Sent:	Friday, August 18, 2000 3:01 AM
> To:	sql language
> Subject:	[sql_language] Multipul 'Select INTO' into the same table
> 
> I'm trying to do a Select INTO #TempTable, multipul times.
> 
> Example :-------
> 
> Select *
> Into #TempTable
> From a
> 
> Select *
> Into #TempTable
> From b
> Where 
> 
> ---------------
> I have several Tables I would like to get data from and insert the data 
> into the #TempTable
> 
> Every time I do a Select INTO it drops all the info previously in 
> #TempTable.
> 
> Is there a way to preserve the Data in a Temporary table and insert new 
> data with a Select INTO.
> 
> Thank you,
> Chris
>