I'm looking to do a single query to update a database. Here is some pseudocode:
UPDATE Table1 SET Table1.Value = (SELECT Value FROM Table2 WHERE Table2.Id==2) WHERE Table1.Id == 4
views:
23answers:
1
+1
A:
This will only work if your subquery (SELECT Value FROM Table2 WHERE Table2.Id=2) only returns one value. Also replace the == with = in your subquery as I have.
I believe updating it to what I have below would make it work no matter what:
(SELECT Top (1) Value FROM Table2 WHERE Table2.Id=2)
Abe Miessler
2010-07-01 22:07:20
If by "would make it work" you mean "would silently pick one value arbitrarily" then, yeah sure.
onedaywhen
2010-07-02 10:52:58
Yeah... That's what I meant. I'm impressed you could point that out though. Give yourself a pat on the back.
Abe Miessler
2010-07-02 16:28:35