select XMOU 
from Table1 where ...stuff...;

select YBLLD_MOU 
from Table2 where ...morestuff...;

select ZCNT_CALL 
from Table3 where ...otherstuffr...;

##</code><code>##

select 'XMOU' as the_name, XMOU as the_value 
from Table1 where ...stuff...

union all

select 'YBLLD_MOU', YBLLD_MOU 
from Table2 where ...morestuff...

union all

select 'ZCNT_CALL', ZCNT_CALL 
from Table3 where ...otherstuffr...