SELECT ID, AccountID, FROM DB1.accounts accounts JOIN DB2.characters characters ON characters.AccountID = accounts.ID