So Limno, you're saying I don't need the subquery? I guess that makes sense and will probably remove some of the complexity. I will look in to it, thank you. Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. This is the place for advice and discussions 0 2. Learn more. Ask Question. Asked 3 years, 10 months ago. Active 3 years, 10 months ago. Viewed 1k times. I'm looking for the query which can update multiple rows by each values selected by sub-query.
Rohan Kishibe Rohan Kishibe 1 1 gold badge 7 7 silver badges 24 24 bronze badges. The error and its cause is plain to see: the subquery is returning more than one row. And you are in the best position to fix the logic. TimBiegeleisen I can get values what I want to update by the subquery, but is it impossible to update multiple rows by multiple results?
Add a comment. Active Oldest Votes. Note that ID is the primary key in the table. ID, tm. ID I get incorrect syntax. Beth 9, 1 1 gold badge 20 20 silver badges 40 40 bronze badges. Nate Pet Nate Pet 40k gold badges silver badges bronze badges.
Add a comment. Active Oldest Votes. Ali M. Ali Sign up or log in Sign up using Google. Sign up using Facebook.
0コメント