Kraer, Joseph wrote:
> I am trying to update a couple of rows in a table by doing the
> update table
> set column5 = number1
> where column 1 = number2
> and column1 = number3
This appears to be correct syntax.
> but it is not working.
We can't help you if you don't tell us what you mean by "not working". Do you
get an error message? If so, what is it? Do you get unexpected results? If
so, tell us what you expected and what you got.
> I tried listing the conditions separated by
> commas (where column 1 = number2, column1 = number3) and also didn't
> work. What am I doing wrong?
Because that isn't valid syntax. Don't make things up. Read the manual
instead. UPDATE syntax is described in detail
> Thanks in advance,
> Joseph "Tito" Kraer
> Business Systems Analyst
> Taylor, Bean & Whitaker Mortgage Corp