Explain the differences between various SQL joins and write a query demonstrating a complex multi-table join.
