请帮忙看下通过表2的内容更新表1的有关问题

请帮忙看下通过表2的内容更新表1的问题
表1
ID    eventID    Name      State      Description
1      e1                                          描述1
2      e2                                          描述2
3      e2                                          描述3
4      e3                                          描述4

表2
ID      eventID     Name      State
1        e2             事件2       open
2        e3             事件3       close
3        e4             事件4       open

期望结果
ID    eventID    Name      State      Description
1      e1                                          描述1
2      e2            事件2       open      描述2
3      e2            事件2       open      描述3
4      e3            事件3       close      描述4

------解决思路----------------------
update   b1  set  Name=b2.Name,State=b2.State from 表1 b1,表2  b2 where  b1.eventID=b2.eventID