Home mysql Subquery Returns More Than 1 Row

Subquery Returns More Than 1 Row




Here is an error in this query, how to fix it?

Answer 1, Authority 100%

The whole problem is described in the title of the question. One of your subqueries

(Select Points
  From oc_product_reward pr.
  Where pr.product_id = p.Product_ID
   And customer_group_id = '1') AS REWARD,
  From oc_stock_status ss.
  Where ss.stock_status_id = p.stock_status_id
   And ss.language_id = '1') as Stock_status,
 (Select wcd.unit.
  From oc_weight_class_description WCD.
  Where P.Weight_Class_id = wcd.weight_class_id
   And wcd.language_id = '1') as weight_class,
 (Select lcd.unit.
  Where P.Length_Class_ID = lcd.length_class_id
   And lcd.language_id = '1') AS LENGTH_CLASS,

returned more than one value (which is unacceptable). Which one, no one will tell you, because, without seeing the data itself, it is impossible to do. The simplest solution is to add to them Limit 1 , but how correctly it will be correct, solve only you.

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions