Posted by Greg D. Moore \(Strider\) on 04/22/06 18:46

"Rico" <me@you.com> wrote in message news:f2s2g.5832$Fd6.4310@edtnps82...
> Just because I don't know the address, doesn't mean the people that own it
> can sell it (UPDATE People Set Owner=NewOwner).

Congratulations, you've just updated every record in your table to the new
owner.

In other words, you've just sold every house on the block to the same
person.

You need a where clause and in order to pick a SPECIFIC house, you need
something that ID's it uniquely.


>
> "Lyle Fairfield" <lylefairfield@aim.com> wrote in message
> news:1145701034.778574.144660@e56g2000cwe.googlegroups.com...
> > How would you find the house if you didn't know the address?
> >
>
>

[Back to original message]