How about this:

select

es.session_id,

er.session_id,

er.dbid,

db_name(er.dbid)

from

sys.dm_exec_sessions es

inner join sys.dm_exec_requests er on es.session_id = er.session_id;

Edit: Corrected a couple of aliases.