Posted by Andrew Clark on 02/02/06 17:58

"Alexander Kuznetsov" <AK_TIREDOFSPAM@hotmail.COM> wrote in
news:1138895559.862884.111780@g47g2000cwa.googlegroups.com:

> UPDATE @workdates
> SET conflict = 'X'
> FROM @workdates w, @existing s
> WHERE w.workdate = s.workdate
>
>

But is the original statement valid?

UPDATE @workdates
SET conflict = 'X'
FROM @existing s
WHERE workdate = s.workdate

Andrew

[Back to original message]