select fielda, fieldb, fieldc
from JAN2000
union
select fielda, fieldb, fieldc
from FEB2000
etc. Should do the trick.
--- Howie Hamlin <[EMAIL PROTECTED]> wrote:
> I have a client application where monthly data are
> stored in a single
> database (Access 2K for now) but in separate tables
> (each table has the same
> structure). For example:
>
> JAN2000
> FEB2000
> etc....
>
> Is there any way, besides concatenating these
> tables, to perform a single
> SELECT query on these multiple tables?
>
> Thanks,
>
> Howie Hamlin
> --
> inFusion Project Manager; On-Line Data Solutions,
> Inc. (631)737-4668
> www.CoolFusion.com
>
============================================================
> Please vote for iMS in the Most Innovative category
> here:
> ***
> http://www.sys-con.com/ColdFusion/readerschoice2000/
> ***
>
============================================================
> Check out inFusion Mail Server - the world's most
> configurable email server
>
>
>
------------------------------------------------------------------------------
> Archives:
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to
> [EMAIL PROTECTED] with 'unsubscribe'
> in the body.
__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail – Free email you can access from anywhere!
http://mail.yahoo.com/
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
