blocks|key|3263305|text|select的cost部分中的select语句返回多个值。您需要添加更多的where子句，或者使用聚合。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3263306|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

The select statement in the cost part of your select is returning more than one value. You need to add more where clauses, or use an aggregation.

blocks|key|311284|text|cost+=+Select+Supplier_Item.Price+from+Supplier_Item,orderdetails,Supplier+
+++where+Supplier_Item.SKU=OrderDetails.Sku+and+
++++++Supplier_Item.SupplierId=Supplier.SupplierID|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|311285|此子查询返回多个值，SQL正在抱怨，因为它不能在一条记录中为成本分配多个值。|unstyled|311286|一些想法：|311287|311288|修复数据，使现有的子查询仅返回一条记录|ordered-list-item|311289|修改子查询，使其仅返回一条记录，并在子查询中添加top+1|311290|+order+by+(DBA讨厌的解决方案，但它“有效”)|311291|使用用户定义的函数将子查询的结果连接成单个字符串|311292|<|311293|>G210|311294|311295|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|11|8|@]|9|@]|A|$]]|$1|I|3|-4|5|F|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|13|8|@]|9|@]|A|$]]|$1|M|3|N|5|L|7|14|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|15|8|@]|9|@]|A|$]]|$1|Q|3|R|5|L|7|16|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|17|8|@]|9|@]|A|$]]|$1|U|3|V|5|L|7|18|8|@]|9|@]|A|$]]|$1|W|3|-4|5|F|7|19|8|@]|9|@]|A|$]]|$1|X|3|-4|5|F|7|1A|8|@]|9|@]|A|$]]]|Y|$]]

<pre><code>cost = Select Supplier_Item.Price from Supplier_Item,orderdetails,Supplier 
 where Supplier_Item.SKU=OrderDetails.Sku and 
 Supplier_Item.SupplierId=Supplier.SupplierID
</code></pre>

This subquery returns multiple values, SQL is complaining because it can't assign multiple values to cost in a single record.

Some ideas:

<ol>
<li>Fix the data such that the existing subquery returns only 1 record</li>
<li>Fix the subquery such that it only returns one record</li>
<li>Add a top 1 and order by to the subquery (nasty solution that DBAs hate - but it "works")</li>
<li>Use a user defined function to concatenate the results of the subquery into a single string</li>
</ol>

blocks|key|311326|text|该错误表示此子查询返回的行超过1行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|311327|(Select+Supplier_Item.Price+from+Supplier_Item,orderdetails,Supplier+where+Supplier_Item.SKU=OrderDetails.Sku+and+Supplier_Item.SupplierId=Supplier.SupplierID+)|code-block|syntax|javascript|311328|您可能不希望在子查询中包括orderdetails和supplier表，因为您希望在外部查询中引用从这些表中选择的值。因此，我认为您希望该子查询简单如下：|311329|(Select+Supplier_Item.Price+from+Supplier_Item+where+Supplier_Item.SKU=OrderDetails.Sku+and+Supplier_Item.SupplierId=Supplier.SupplierID+)|311330|我建议您阅读相关的子查询和不相关的子查询。|311331|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

The error implies that this subquery is returning more than 1 row:

<pre><code>(Select Supplier_Item.Price from Supplier_Item,orderdetails,Supplier where Supplier_Item.SKU=OrderDetails.Sku and Supplier_Item.SupplierId=Supplier.SupplierID )
</code></pre>

You probably don't want to include the orderdetails and supplier tables in the subquery, because you want to reference the values selected from those tables in the outer query. So I think you want the subquery to be simply:

<pre><code>(Select Supplier_Item.Price from Supplier_Item where Supplier_Item.SKU=OrderDetails.Sku and Supplier_Item.SupplierId=Supplier.SupplierID )
</code></pre>

I suggest you read up on correlated vs. non-correlated subqueries.

blocks|key|3049766|text|修复方法是停止使用相关子查询，转而使用连接。相关子查询本质上是游标，因为它们导致查询逐行运行，应该避免。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3049767|您可能需要在连接中使用派生表，以便在字段中获得您想要的值。如果您希望只有一条记录匹配，那么普通的join将执行此操作，但您将在结果集中获得同一id的多条记录。如果你只想要一个，你需要决定哪一个，并在代码中做到这一点，你可以使用带有order+by的top+1，你可以使用max()，你可以使用min()，等等，这取决于你对数据的实际需求。|offset|length|style|CODE|3049768|entityMap^0|0|1C|4|37|8|3G|5|3R|5|42|5|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]|$D|N|E|O|F|G]|$D|P|E|Q|F|G]|$D|R|E|S|F|G]|$D|T|E|U|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$]]

The fix is to stop using correlated subqueries and use joins instead. Correlated subqueries are essentially cursors as they cause the query to run row-by-row and should be avoided.

You may need a derived table in the join in order to get the value you want in the field if you want only one record to match, if you need both values then the ordinary <code>join</code> will do that but you will get multiple records for the same id in the results set. If you only want one, you need to decide which one and do that in the code, you could use a <code>top 1</code> with an <code>order by</code>, you could use <code>max()</code>, you could use <code>min()</code>, etc, depending on what your real requirement for the data is.

blocks|key|3049781|text|正如其他人所建议的那样，最好的方法是使用连接而不是变量赋值。重写查询以使用连接(并使用显式连接语法而不是隐式连接，这也是建议的--也是最佳实践)，您将得到类似如下的结果：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3049782|select++
++OrderDetails.Sku,
++OrderDetails.mf_item_number,
++OrderDetails.Qty,
++OrderDetails.Price,
++Supplier.SupplierId,+
++Supplier.SupplierName,
++Supplier.DropShipFees,+
++Supplier_Item.Price+as+cost
from+
++OrderDetails
join+Supplier+on+OrderDetails.Mfr_ID+=+Supplier.SupplierId
join+Group_Master+on+Group_Master.Sku+=+OrderDetails.Sku+
join+Supplier_Item+on+
++Supplier_Item.SKU=OrderDetails.Sku+and+Supplier_Item.SupplierId=Supplier.SupplierID+
where+
++invoiceid='339740'+|code-block|syntax|javascript|3049783|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

As others have suggested, the best way to do this is to use a join instead of variable assignment. Re-writing your query to use a join (and using the explicit join syntax instead of the implicit join, which was also suggested--and is the best practice), you would get something like this:

<pre><code>select 
 OrderDetails.Sku,
 OrderDetails.mf_item_number,
 OrderDetails.Qty,
 OrderDetails.Price,
 Supplier.SupplierId, 
 Supplier.SupplierName,
 Supplier.DropShipFees, 
 Supplier_Item.Price as cost
from 
 OrderDetails
join Supplier on OrderDetails.Mfr_ID = Supplier.SupplierId
join Group_Master on Group_Master.Sku = OrderDetails.Sku 
join Supplier_Item on 
 Supplier_Item.SKU=OrderDetails.Sku and Supplier_Item.SupplierId=Supplier.SupplierID 
where 
 invoiceid='339740' 
</code></pre>

blocks|key|3049795|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3049796|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'|code-block|syntax|javascript|3049797|这将返回除了cost列之外的多个相同的行。查看返回的不同成本值，并找出导致不同值的原因。然后询问某人他们想要的成本值，并将条件添加到将选择该成本的查询中。|offset|length|style|CODE|3049798|entityMap^0|0|0|6|4|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Try this:

<pre><code>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'
</code></pre>

This will return multiple rows that are identical except for the <code>cost</code> 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.

blocks|key|311361|text|要么你的数据不好，要么它的结构不是你想的那样。可能两者都有。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|311362|要证明/反驳这一假设，请运行以下查询：|311363|SELECT+*+from
(
++++SELECT+count(*)+as+c,+Supplier_Item.SKU
++++FROM+Supplier_Item
++++INNER+JOIN+orderdetails
++++++++ON+Supplier_Item.sku+=+orderdetails.sku
++++INNER+JOIN+Supplier
++++++++ON+Supplier_item.supplierID+=+Supplier.SupplierID
++++GROUP+BY+Supplier_Item.SKU
)+x
WHERE+c+>+1
ORDER+BY+c+DESC|code-block|syntax|javascript|311364|如果这只返回了几行，那么您的数据就是错误的。如果它返回很多行，那么您的数据结构就不是您所认为的那样。(如果它返回零行，我就错了。)|311365|我猜您的订单多次包含相同的SKU+(两个单独的行项目，都订购相同的SKU)。|CODE|311366|entityMap^0|0|N|0|0|0|0|D|3|X|3|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|W|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|X|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|Y|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|Z|8|@$9|10|A|11|B|Q]|$9|12|A|13|B|Q]]|D|@]|E|$]]|$1|R|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|S|$]]

Either your data is bad, or it's not structured the way you think it is. Possibly both.

To prove/disprove this hypothesis, run this query:

<pre><code>SELECT * from
(
 SELECT count(*) as c, Supplier_Item.SKU
 FROM Supplier_Item
 INNER JOIN orderdetails
 ON Supplier_Item.sku = orderdetails.sku
 INNER JOIN Supplier
 ON Supplier_item.supplierID = Supplier.SupplierID
 GROUP BY Supplier_Item.SKU
) x
WHERE c &gt; 1
ORDER BY c DESC
</code></pre>

If this returns just a few rows, then your data is bad. If it returns lots of rows, then your data is not structured the way you think it is. (If it returns zero rows, I'm wrong.)

I'm guessing that you have orders containing the same <code>SKU</code> multiple times (two separate line items, both ordering the same <code>SKU</code>).

blocks|key|3049862|text|检查您试图对其执行查询的表上是否有任何触发器。当他们试图运行表上的update/select/insert触发器时，有时会抛出此错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3049863|您可以修改您的查询以禁用触发器，如果触发器没有，则需要为您试图运行的任何查询执行触发器。|offset|length|style|BOLD|3049864|ALTER+TABLE+your_table+DISABLE+TRIGGER+[the_trigger_name]

UPDATE++++your_table
SET+++++Gender+=+'Female'
WHERE+++++(Gender+=+'Male')

ALTER+TABLE+your_table+ENABLE+TRIGGER+[the_trigger_name]|code-block|syntax|javascript|3049865|entityMap^0|0|L|2|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|S|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Check to see if there are any triggers on the table you are trying to execute queries against. They can sometimes throw this error as they are trying to run the update/select/insert trigger that is on the table.

You can modify your query to disable then enable the trigger if the trigger DOES NOT need to be executed for whatever query you are trying to run.

<pre><code>ALTER TABLE your_table DISABLE TRIGGER [the_trigger_name]

UPDATE your_table
SET Gender = 'Female'
WHERE (Gender = 'Male')

ALTER TABLE your_table ENABLE TRIGGER [the_trigger_name]
</code></pre>

blocks|key|3049890|text|SELECT+COLUMN+
++++FROM+TABLE+
WHERE+columns_name
++++IN+(+SELECT+COLUMN+FROM+TABLE+WHERE+columns_name+=+'value');|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3049891|注意:当我们使用子查询时，我们必须关注以下几点：|unstyled|3049892|3049893|如果我们的子查询返回1个值，在这种情况下，我们需要使用(=，!=，<>，<，>...)|ordered-list-item|3049894|else(多个值)，在这种情况下，我们需要使用(+in，any，<>，|3049895|)|3049896|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|R|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|S|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|J|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|F|7|W|8|@]|9|@]|A|$]]]|P|$]]

<pre><code>SELECT COLUMN 
 FROM TABLE 
WHERE columns_name
 IN ( SELECT COLUMN FROM TABLE WHERE columns_name = 'value');
</code></pre>

note: when we are using sub-query we must focus on these points:

<ol>
<li>if our sub query returns 1 value in this case we need to use (=,!=,&lt;>,&lt;,>....)</li>
<li>else (more than one value), in this case we need to use (in, any, all, some )</li>
</ol>

blocks|key|3049912|text|我也遇到了同样的问题，我使用了in而不是=，来自Northwind数据库示例：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3049913|3049914|查询是:查找1997年下订单的公司|blockquote|3049915|3049916|3049917|试试这个：|3049918|SELECT+CompanyName
++++FROM+Customers
WHERE+CustomerID+IN+(
++++++++++++++++++++++++SELECT+CustomerID+
++++++++++++++++++++++++++++FROM+Orders+
++++++++++++++++++++++++WHERE+YEAR(OrderDate)+=+'1997'
++++++++++++++++++++);|code-block|syntax|javascript|3049919|而不是这样：|3049920|SELECT+CompanyName
++++FROM+Customers
WHERE+CustomerID+=
(
++++SELECT+CustomerID+
++++++++FROM+Orders+
++++WHERE+YEAR(OrderDate)+=+'1997'
);|3049921|entityMap^0|F|2|K|1|O|9|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]|$9|13|A|14|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|15|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|16|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|17|8|@]|D|@]|E|$]]|$1|K|3|-4|5|6|7|18|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|19|8|@]|D|@]|E|$]]|$1|N|3|O|5|P|7|1A|8|@]|D|@]|E|$Q|R]]|$1|S|3|T|5|6|7|1B|8|@]|D|@]|E|$]]|$1|U|3|V|5|P|7|1C|8|@]|D|@]|E|$Q|R]]|$1|W|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]]|X|$]]

I had the same problem , I used <code>in</code> instead of <code>=</code> , from the <code>Northwind</code> database example :

<blockquote>
 Query is : Find the Companies that placed orders in 1997
</blockquote>

Try this : 

<pre><code>SELECT CompanyName
 FROM Customers
WHERE CustomerID IN (
 SELECT CustomerID 
 FROM Orders 
 WHERE YEAR(OrderDate) = '1997'
 );
</code></pre>

Instead of that : 

<pre><code>SELECT CompanyName
 FROM Customers
WHERE CustomerID =
(
 SELECT CustomerID 
 FROM Orders 
 WHERE YEAR(OrderDate) = '1997'
);
</code></pre>

blocks|key|3263556|text|即使在最初的帖子写了9年后，这对我也很有帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3263557|如果您在没有任何线索的情况下收到这些类型的错误，则应该有一个触发器、与表相关的函数，显然，它应该以SP结束，或者具有选择/筛选数据而不使用主唯一列的函数。如果您使用主唯一列进行搜索/过滤，则不会有任何多个结果。尤其是在为已声明的变量赋值时。SP不会给您en错误，而只会给您一个运行时错误。|offset|length|style|BOLD|3263558|+"System.Data.SqlClient.SqlException+(0x80131904):+Subquery+returned+more+than+1+value.+This+is+not+permitted+when+the+subquery+follows+=,+!=,+<,+<=+,+>,+>=+or+when+the+subquery+is+used+as+an+expression.
++++The+statement+has+been+terminated."|code-block|syntax|javascript|3263559|在我的例子中，显然没有线索，只有这条错误消息。有一个触发器连接到表，由触发器更新的表也有另一个触发器，同样，它有两个触发器，最后有一个SP。SP具有导致多行的select子句。|3263560|SET+@Variable1+=(
++++++++SELECT+column_gonna_asign
++++++++FROM+dbo.your_db
++++++++WHERE+Non_primary_non_unique_key=+@Variable2|3263561|如果这返回多行，那么您就有麻烦了。|3263562|entityMap^0|0|1T|4|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@$D|W|E|X|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|Y|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|10|8|@]|9|@]|A|$K|L]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

Even after 9 years of the original post, this helped me. 

If you are receiving these types of errors without any clue, there should be a trigger, function related to the table, and obviously it should end up with an SP, or function with selecting/filtering data NOT USING Primary Unique column. If you are searching/filtering using the Primary Unique column there won't be any multiple results. Especially when you are assigning value for a declared variable. The SP never gives you en error but only an runtime error.

<pre><code> "System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &lt;, &lt;= , &gt;, &gt;= or when the subquery is used as an expression.
 The statement has been terminated."
</code></pre>

In my case obviously there was no clue, but only this error message. There was a trigger connected to the table and the table updating by the trigger also had another trigger likewise it ended up with two triggers and in the end with an SP. The SP was having a select clause which was resulting in multiple rows.

<pre><code>SET @Variable1 =(
 SELECT column_gonna_asign
 FROM dbo.your_db
 WHERE Non_primary_non_unique_key= @Variable2
</code></pre>

If this returns multiple rows, you are in trouble.

I run the following query:

<pre><code>SELECT 
 orderdetails.sku,
 orderdetails.mf_item_number,
 orderdetails.qty,
 orderdetails.price,
 supplier.supplierid,
 supplier.suppliername,
 supplier.dropshipfees,
 cost = (SELECT supplier_item.price
 FROM supplier_item,
 orderdetails,
 supplier
 WHERE supplier_item.sku = orderdetails.sku
 AND supplier_item.supplierid = supplier.supplierid)
FROM orderdetails,
 supplier,
 group_master
WHERE invoiceid = '339740'
 AND orderdetails.mfr_id = supplier.supplierid
 AND group_master.sku = orderdetails.sku 
</code></pre>

I get the following error:

<blockquote>
 Msg 512, Level 16, State 1, Line 2
 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &lt;, &lt;= , >, >= or when the subquery is used as an expression.
</blockquote>

Any ideas?

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

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我运行以下查询：SELECT    orderdetails.sku,   orderdetails.mf_item_number,   orderdetails.qty,   orderdetails.price,   supplier.supplierid,   supplier.suppliername,   s...

问SQL Server子查询返回了多个值。当子查询跟在=，!=，<，<=，>，>=之后时，这是不允许的
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server子查询返回了多个值。当子查询跟在=，!=，<，<=，>，>=之后时，这是不允许的EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server子查询返回了多个值。当子查询跟在=，!=，<，<=，>，>=之后时，这是不允许的
EN