none
Update with From clause

    Question

  • Hi, are there plans to support transact SQL for "Update table" with "From"-clause? With actual 3.5 an

    update table1 set field=table2.field from table1 inner join table2 on table1.field=table2.field

    doesn't work.

    best regards, Toni

    Friday, October 8, 2010 4:29 PM

Answers

  • Suggest you post a request a Connect.microsoft.com
    Visit my SQL Compact blog - http://erikej.blogspot.com - Please mark as answer, if this was it.
    • Marked as answer by tonisa Saturday, October 9, 2010 7:09 PM
    Saturday, October 9, 2010 9:46 AM
    Moderator