Update with From clause


  • 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


  • Suggest you post a request a
    Visit my SQL Compact blog - - 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