Unable to run an Insert query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

This query hangs in the middle of executing...It's fairly simple, and I
cannot see what's wrong with it. Please help !!!!

INSERT INTO HIPlanNames
SELECT [2004_HiPlanNames_ADD].*
FROM 2004_HiPlanNames_ADD, HiPlanNames;

Thank you in advance.
 
Dear Luther:

It seems unusual to me you would use a cross-product of the two tables.
That's what's in your FROM clause.

I don't know how many rows are in each table. The number of rows produced
by the cross product would be found my mulitplying the number of rows in
each table. That could be a very large number of rows, and could take a
very long time to run, giving the appearance of "hanging".

Change the query so the last line is:

FROM 2004_HiPlanNames_ADD

Tom Ellison
 
Back
Top