> Is there any way, besides concatenating these tables, to perform a single
> SELECT query on these multiple tables?
How about:
SELECT * FROM JAN2000
UNION
SELECT * FROM FEB2000
UNION
SELECT * FROM MAR2000
As long as the column names and number of columns in the select list for
each table are the same you can "UNION" them I think.
- Sean
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sean Daniels
Manager, Engineering
Marketplace Technologies
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
tel: 207.439.6030
cel: 978.764.0779
http://www.dealforce.com
http://www.dealstream.com
http://www.mergernetwork.com
> 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....
>
>
> 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/[email protected]/
> 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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
