DuneSQL Joining Tables with Same Column Excludes Data

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. https://dune.com/queries/2349030