[SQL] Subquery returned more than 1 value
Subquery returned more than 1 value
比較常出現的情況是使用SubQuery做為欄位值
例如 Select a, (Select b from TableB Where TableA.id = TableB.id) as c from TableA
當Select b from TableB Where TableA.id = TableB.id返回的結果大於1筆時就會出現上述錯誤
比較常出現的情況是使用SubQuery做為欄位值
例如 Select a, (Select b from TableB Where TableA.id = TableB.id) as c from TableA
當Select b from TableB Where TableA.id = TableB.id返回的結果大於1筆時就會出現上述錯誤
Comments
Post a Comment