Here's my update statement:
UPDATE Item1
SET reviewloop = 1, currentreviewstate=5
WHERE itemid in
(SELECT itemid FROM Item2)
The thing is: the table Item2 DOES NOT HAVE a field called itemid.
So, I should receive an error, right? Not so.Instead, every single
record in Item1 was updated.
Does anyone know why SQL Serverr does not trown an error???
Thanks guys,
-Silvio Souza