SQL Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, =

by

Try this:

SELECT
    od.Sku,
    od.mf_item_number,
    od.Qty,
    od.Price,
    s.SupplierId,
    s.SupplierName,
    s.DropShipFees,
    si.Price as cost
FROM
    OrderDetails od
    INNER JOIN Supplier s on s.SupplierId = od.Mfr_ID
    INNER JOIN Group_Master gm on gm.Sku = od.Sku
    INNER JOIN Supplier_Item si on si.SKU = od.Sku and si.SupplierId = s.SupplierID
WHERE
    od.invoiceid = '339740'

This will return multiple rows that are identical except for the cost column. Look at the different cost values that are returned and figure out what is causing the different values. Then ask somebody which cost value they want, and add the criteria to the query that will select that cost.

More Related Contents:

  1. SQL where clause odd behavior [closed]
  2. How do I escape a single quote in SQL Server?
  3. Simple way to transpose columns and rows in SQL?
  4. Only inserting a row if it’s not already there
  5. Unpivot with column name
  6. Selecting data from two different servers in SQL Server
  7. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  8. How important is the order of columns in indexes?
  9. How to split a single column values to multiple column values?
  10. Why no windowed functions in where clauses?
  11. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  12. T-SQL Cast versus Convert
  13. When no ‘Order by’ is specified, what order does a query choose for your record set?
  14. What is a stored procedure?
  15. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  16. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  17. Partition Function COUNT() OVER possible using DISTINCT
  18. How do I create a foreign key in SQL Server?
  19. How do I group on continuous ranges
  20. join comma delimited data column
  21. Need to list all triggers in SQL Server database with table name and table’s schema
  22. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  23. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  24. Alter user defined type in SQL Server
  25. Best equivalent for IsInteger in SQL Server
  26. Store multiple bit values in a single table column
  27. SQL Server equivalent to MySQL enum data type?
  28. SQL – Call Stored Procedure for each record
  29. Why is RAND() not producing random numbers?
  30. Should every SQL Server foreign key have a matching index? [closed]

Leave a Comment