Re: Update phone inner join tmpphone....

>I tried this query: > >Update phone inner join tmpphone on phone.empno = tmpphone.empno >set >phone.lname = tmpphone.lname, >phone.fname = tmpphone.fname > >and it didn't work. > >This works in MSAccess. > >Is this syntax (or something like it) suppo

Update phone inner join tmpphone....

I tried this query: Update phone inner join tmpphone on phone.empno = tmpphone.empno set phone.lname = tmpphone.lname, phone.fname = tmpphone.fname and it didn't work. This works in MSAccess. Is this syntax (or something like it) supported by

Update phone inner join tmpphone....

I tried this query: Update phone inner join tmpphone on phone.empno = tmpphone.empno set phone.lname = tmpphone.lname, phone.fname = tmpphone.fname and it didn't work. This does work in MSSqlServer 7. Is this syntax (or something like it) supported by