Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Merge two tables?
Fri, Jul 14 2006 2:02 PMPermanent Link

KP
Hi ~

how can I merge two tables with identical structure?

TIA
KP
Fri, Jul 14 2006 2:55 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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

Image