sorry I'm still confused..

Do I write this in a 'new query'?

Where will the #tableB appear in?

Thanks.

i want to copy (duplicate) the data in col (A, B, C) into TempTable. But previously when I wrote the SQL statement Select a,b,c Into #temptable, it shifted all the...