How would you write an efficient SQL query to combine disparate tables into a unified view of the GameStop customer?