如何在更新查询中使用JOIN

I am very weak at join and i need to know that how can i convert following query using joins. This Query is working fine with sub queries but i need to convert it and use it making joins.I am very weak at join and i need to know that