Using Select * to join Tables only brings in 1 column even when they aren't Identical.
For instance, connecting ERC20 Transfers to ERC20 Tokens brings in the contract_address column from ERC20.Tokens which doesn't have every ERC20 Token. Its a difficult to spot problem and a very common table join for new users.