Write a SQL query using inner and left joins to retrieve specific customer records across three related tables.