|
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..
Navigation:
[Reply to this message]
|