Primary Table and Archive Combine

[jglassner]

Hello

Before I ask the question I know if I had not created and archive table from my primary table I would not have this issue. However, offloading years of data that is not used all that much really sped things up.

So, now I been asked to run a report for the life of the project and I need to combine the data while keeping the tables separate. I am looking to combine certain data fields to get a count of the total. Both tables are exactly the same.

Example
Primary Table Project Date + Primary Archive Project Date.

I assume a query would be the answer but I can not seem to get the two tables to merge.

Thanks,
Jason

 

[sandy666]

Both tables are exactly the same.

so why you want to merge these two?
I'm just asking out of curiosity

 

[JonXL]

You want a UNION query. Something like...

SELECT FIELD1, FIELD2
FROM ACTIVE_TABLE
UNION ALL
SELECT FIELD1, FIELD2
FROM ARCHIVE_TABLE

Save this as a query and then create new queries referencing it to pull all the reporting.

 

[Joe4]

so why you want to merge these two?
I'm just asking out of curiosity

I am pretty sure that they mean the table structures, not the table data.

 

[sandy666]

I am pretty sure that they mean the table structures, not the table data.

this is just your interpretation, I don't see the confirmation / denial from OP ?

 

[xenou]

I would imagine JonXL is on the right track...

Note: UNION vs UNION ALL could make a difference. UNION by default will discard duplicates which may affect your count if there are duplicates...

 

[Joe4]

this is just your interpretation, I don't see the confirmation / denial from OP

I think it can be pretty easily inferred, if you read the entire question in its context.

...However, offloading years of data that is not used all that much really sped things up.

So, now I been asked to run a report for the life of the project and I need to combine the data while keeping the tables separate.

 

[sandy666]

I think it can be pretty easily inferred, if you read the entire question in its context.

Both tables are exactly the same.

one contradicts the other
that's why I asked the question.
i'd suggest to the op AND not XOR ? , not guessing but certainty

 

[Micron]

I think it can be pretty easily inferred, if you read the entire question in its context.

Sometimes, only a part of it can be relied on. I'd defer to this statement as the rest is not crystal clear:

I need to combine the data while keeping the tables separate.

which I take to mean that data is to be temporarily merged as a query would do.

 

[jglassner]

You want a UNION query. Something like...

SELECT FIELD1, FIELD2
FROM ACTIVE_TABLE
UNION ALL
SELECT FIELD1, FIELD2
FROM ARCHIVE_TABLE

Save this as a query and then create new queries referencing it to pull all the reporting.

THANK YOU