Posted by --CELKO-- on 09/21/05 11:48

>> Products.lhs1_id = lhs1.id <<

Why did a data element change names from table to table? Why do so
many of your data elements violate the rules of data modeling and
ISO-11179?

I would bet that this magical table, Temp, is not needed but is used to
mimic a scratch tape in a procedural solution. It is a common Newbie
error. You probably ought to get some help on the entire schema.

Otherwise, go to BOL and look up INSERT INTO .. SELECT..

[Back to original message]