Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
DBISAM Technical Support
»
Support Forums
»
DBISAM SQL
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Merge two tables?
Fri, Jul 14 2006 2:02 PM
Permanent Link
KP
Hi ~
how can I merge two tables with identical structure?
TIA
KP
Fri, Jul 14 2006 2:55 PM
Permanent Link
Tim Young [Elevate Software]
Elevate Software, Inc.
timyoung@elevatesoft.com
<< how can I merge two tables with identical structure? >>
Is this DBISAM version 4.x ? If so, then this will do it:
SELECT * FROM FirstTable
UNION
SELECT * FROM SecondTable
--
Tim Young
Elevate Software
www.elevatesoft.com