Joins on the tables you know, with new questions. Before each join, say which table must keep all its rows and what the key is. After it, compare the row count with what you expected.
The traps from the unit come back: unmatched rows that an inner join drops, a key listed twice that multiplies rows, a filtering join that should add no columns, and columns that don't line up when stacking.