In SBT, for some asinine reason known only to them, they split their data into current and history tables. These tables are identical in structure and just have a slightly different name.

The reports I'm writing rely on data that can be either current or historical. So I have to deal with both tables.

What I've been doing is using an SQL UNION to join the two tables into a third and working with that. Unfortunately, since the client has cleaned out their data since '94, this process takes forever on my 433. On their 166s, I can imagine it will just scream.

Is there a better way to deal with this? The FoxFire reports can handle it without hardly a pause so there must be some way. Not being privy to the ways of FoxFire, I thought I'd ask here.

Thanks,

Michelle