I have a temp table I am trying to update with values from another column from another table that I have to join on itself. I keep getting a subquery error. How do I resolve this subquery error? The values will be different on some occasions so I may have more than one value returned on my select:
set price_ID = (Select tbl1.price_ID FROM loaded_pricecodes as lc
WHERE lc.INTERNAL_Price_Code = '777777'
AND lc.price_ID IS not NULL)