or without the join
select db_name(database_id), name, physical_name
from sys.master_files
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉