Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Merge 2 tables in V4.xx with blob columns?
Thu, Oct 19 2006 6:27 PMPermanent Link

KP
Hi ~

how can I merge two tables with identical structure in 4.xx?

Note: Tried "unioning" them together - but tables contain BLOB columns
and receive error 11949 'You cannot UNION queries containing BLB columns'


TIA
KP
Thu, Oct 19 2006 6:31 PMPermanent Link

KP
Guess I could have tried a

insert into A select from B......

Fri, Oct 20 2006 2:16 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Kai,

<< Guess I could have tried a

insert into A select from B...... >>

That will work, however it won't remove duplicates.  I'm not sure if that's
what you wanted or not.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image