EasyCFM.COM ColdFusion Forums / MS Access Related Issues / Adding Data to a Access Table

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Adding Data to a Access Table

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

StoneRose
03-25-2010 @ 11:23 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 80
Joined: Dec 2008

Two tables, same fields, I want to join them into a new table (or add one into the other).

What's the best way?



Webmaster
03-26-2010 @ 1:02 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Administrator
Posts: 4542
Joined: Jan 2002

If you are on a MSSQL server, you can use UNION.

<cfquery ...>
select field from table

UNION ALL

select field from table
</cfquery>

If this is on Access or  two separate databases (or
even two databases on two different servers, checkout:
http://tutorial98.easycfm.com/ )

HTH ~P

Pablo Varando
Senior Application Architect
EasyCFM.COM, LLC.

904.483.1457 \\ mobile
webmaster@easycfm.com \\email

\m/ (>.<) \m/
--- rock on ---


Website Designed and Developed by Pablo Varando.