>Hello all!
>
>Im wrote a query
>
>UPDATE otest SET otest.id=dup.id;
>WHERE;
>otest.bdate=dup.bdate;
>AND;
>otest.fname=dup.fname
>
>
>but ive noticed this query doesnt work when i leave in the Fname which is a character but it queries fien using the date only, the Fname is a character. Can i not do that with a charactER?
Try using UPDATE FROM even though it may go against ANSI standards as shown in Hugo Kornelis blog.
http://sqlblog.com/blogs/hugo_kornelis/archive/2008/03/10/lets-deprecate-update-from.aspxUPDATE otest SET otest.id=dup.id;
from oTest inner join dup ON
otest.bdate=dup.bdate;
AND;
otest.fname=dup.fname
If it's not broken, fix it until it is.
My Blog