"Boyd E. Hemphill" <[EMAIL PROTECTED]> wrote:
> I am attempting to move two columns of data into a large table by using
> the insert into . select . construct. My problem is that I need to
> join to the table I am inserting to. To get around this my idea is to
> create a temporary database and p
Perhaps I'm misunderstanding what you want, but could you create your
temporary table as the result of your construct, then insert it into
your table? If I'm reading you correctly, I think that would involve
less data in the temporary table, so might be faster overall. Something
like:
CREA
Hello to all:
I am attempting to move two columns of data into a large table by using
the insert into . select . construct. My problem is that I need to
join to the table I am inserting to. To get around this my idea is to
create a temporary database and populate it with the table then join to