In theory - everything is a left join when you are hitting other tables - but with transaction lines being many to 1, joining to transactions together can often result in multiplicative results.