Select into/update

[dr4ke]

Hello,

I currently use lots of UNION queries in my Database, which is a huge strain on performance and i'm looking to adopt a different method. I would like to create a tempory table, which does two things. Depending on the query I will write, I would like some data to be 'updated' into the table and therefore not delete it. And I would like some data to completely override what is already in there.

To Summarise...

This Query (call it 'Query2') will replace anything in 'TemporyTable' with anything that is in 'Query1' once Query2 has been run.

 SELECT * INTO TemporaryTable
FROM Query1;

What I need is the correct SQL statement to 'add' the information from 'Query1' into 'TemporaryTable' without deleting the current data. I had a go with the below, which simply didn't work. I've used the same naming conventions, as once I understand how it can work I can adopt to what I'm trying to do.

 SELECT UPDATE * INTO TemporaryTable
FROM Query1;

[orange]

Please show your tables and relationships. Getting the database designed to support your "business" is key.

[pbaldy]

Lots of UNION queries is often a sign of a de-normalized design, but what you're looking for is an append query:

INSERT INTO TableName(Field1, Field2)
SELECT Field1, Field2
FROM OtherTableName

[dr4ke]

Thanks PBaldy, could you please break this down?

Is this section the pre-existing table (i.e. 'TemporyTable' in my example)? And would I need to specify what 'fields' to update?

INSERT INTO TableName(Field1, Field2)

Is this where the information is being pulled from, into the 'TemporaryTable' ??

SELECT Field1, Field 2 From OtherTableName

[pbaldy]

Here, I looked in help for you.

[orange]

see
http://www.techonthenet.com/sql/insert.php
http://www.techonthenet.com/sql/update.php

Edit: I see Paul responded while I was typing.

[dr4ke]

Thank you both for your replies. Apologies for the delay in replying, it's been very busy. But this is exactly what I wanted

[pbaldy]

No problem.