Update From Two Tables In Enterprise Manager

Hi,
I'm trying to write a query (in enterprise manager) that will update one table's column with data from another table's column. Yet I can't seem to do it!!! Enterprise Manager won't accept UPDATE.. FROM clause, and I dont know how to do it otherwise!

Here is the structure:

Table A: col a, col b, col c

Table B: col A, col B, col C

I would like to update A.b with the data from B.B for the records where A.c = B.c

Can anyone help!?

Thanks so much!
Ian