I would create a view (in access, a query) that does a UNION of the tables
select field1, field
from table1
union
select field1, field2
from table2...
and do my queries against the view. Or you can code the unions in your
query.
-----Original Message-----
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 25, 2000 2:54 PM
To: [EMAIL PROTECTED]
Subject: Results from several like tables
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/[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.
