Member Avatar for aplee

Hi everyone,
I am getting this error:

Msg 512, Level 16, State 1, Line 1
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.

please help, I have tried to solve it on my own but still can't find the right answer..

this is the query:

[update tbl_M_MasterLogs set rptprobtype =
(Select [Problem Type]
from tbl_rpt_MasterData
where tbl_M_MasterLogs.CaseNo = tbl_rpt_MasterData.CaseNo)

Thank you very much in advance!

  • 2 Contributors
  • 1 Reply
  • 169 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by buddylee17
Member Avatar for buddylee17

Your subquery is returning multiple rows. This could be fixed with a join:

update ML
set ML.rptprobtype = MD.[Problem Type]
FROM tbl_M_MasterLogs ML
JOIN tbl_rpt_MasterData MD ON ML.CaseNo = MD.CaseNo
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.