sql - Where clause with insert statement -


Where is it possible to use with the included statement? In my scenario, how the update query is not being used, because the subkey returns more than one value to my query this way. 

  Select ID from INSERT EntityAttributeValue (EntityID), with more than ID (Selection ID, ROW_NUMBER (more than ID), line from item) x where between row 1 and 400) X where value = '10 kt gold '

What I want to do here, I have the EntityID and value column in the EntityAttributeValue table and other table item table in which the ID is. So this is included in this way: Item.ID = EntityAttributeValue.EntityID Now, I want to put the bulk item ID value in the EntityAttributeValue table from the item table, where value = '10KT Gold '

Please tell me.

There are some problems

  1. Use the code twice in the code even if it works, it will confuse anyone. Use a new name every time.

  2. By adding the name of the table before the column name, make it clear where it comes from.

  3. Where does the value come from ? This is not in the result set for any queries you perform.

    [edit] This query should work: 

      INSERT EntityAttributeValue (EntityID)) Select x2.ID FROM (SELECT x1 .ID FROM (SELECT i.ID, RAD_NUMBER) (ORDER BY I.ID) line from row I) x1 between WHERE line 1 and 400) x2 EntityAttributeValue eav on x2.ID = Eav.EntityID WHERE eav.Value = '10KT Gold'

    But the result is probably not what you want because it will only select items that already have EntityAttributeValue .


Comments

Post a Comment