Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Mon, Oct 19 2009 10:06 AM	Permanent Link
"Sean McDermott"	D2009 DBISAM latest What is the best/easiest way to combine 4 smaller tables into one larger one. I do not need to save the contents of these tables I just need to have all fields hauled into the new table? I only need to do this once. Thanks, S
Mon, Oct 19 2009 10:20 AM	Permanent Link
"Sean McDermott"	Reverse engineering works great, thanks. Sean
Mon, Oct 19 2009 11:15 AM	Permanent Link
adam	I would have said write a simple SQL Statement with an "INTO" clause ... but it seems like you got to a different solution yourself faster! Adam
Mon, Oct 19 2009 12:16 PM	Permanent Link
"Sean McDermott"	Yup, just reverse engineer the 4 tables and then combine into a single SQL CREATE clause in Notepad, cleanup commonalities and remove duplicate indices, etc., and re-run in DBISAM SQL and voila. "adam" <adam@fullwellmill.co.uk> wrote in message news:0D7C9861-4BEA-4949-85FF-E1756FE09C1D@news.elevatesoft.com... >I would have said write a simple SQL Statement with an "INTO" clause ... >but it seems like > you got to a different solution yourself faster! > > Adam >