Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-16 : 18:47:50
|
Kim writes "Hello,
We have a system that breaks up tables into two:
1. table is an active table with same fld amts and named fields
2. table is a history table with same fld amts and named fields
The controller needs to run statistic reports based on data in both tables. Is there a SQL statement that can be used to view them both (they can't be attached)?
Here's a sample of table names:
apdist <--contains data current through 1month worth of data
field 1: cuid
field 2: cvendno
apdisth <--contains history data of 1 month old and older
field 1: cuid
field 2: cvendno
I'm totally lost here..
*Right now the controller is appending both tables into another table each time he needs to run a report." |
|
|
|
|
|
Viewing TWO tables (all same fields) one active/one history