How to write TSQL for inner/left/right/full join in update query

Most of the beginner generally stuck with a problem like how to make a query to update a table by another table or from multiple table data with some conditions. In this post i will try to focus on this area how we can resolve this issue.Let a scenario like you have an online e-commerce site where you sale some products. So when a customer place an order you need to forward this order for