Explain the differences between various SQL joins and write a query to extract specific financial records from two related tables.
