Update SQL Problem

I have problem where I want to update the contents of one field with the contents of another field in another table.

Table A has part and description.
Table B has part and description plus many other fields.

I want to update B's description with the description from A where all the parts are equal.

Can this be done using straight SQL?

Thanks,
Mark Received on Fri Feb 06 1998 - 00:00:00 CST