Write a SQL query utilizing complex inner and outer joins to aggregate customer transaction data across multiple tables.
