When I left join them like this:
select *
from sys.dm_db_missing_index_group_stats AS migs
left JOIN sys.dm_db_missing_index_groups AS mig ON migs.group_handle = mig.index_group_handle
left JOIN sys.dm_db_missing_index_details AS mid ON mig.index_handle = mid.index_handle
I...