Topic: Adding Data to a Access Table


StoneRose    -- 03-25-2010 @ 11:23 PM
  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
  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 ---


EasyCFM.COM ColdFusion Forums : http://archive.easycfm.com/forums
Topic: http://archive.easycfm.com/forums/viewmessages.cfm?Forum=30&Topic=14762