Return blank data if the column is empty in SQL -


i have run following query returns 36 rows of data

select      a.objective, sum(a.t_value)      db2adm2.tfintr10      (a."year" =10)     , (a.objective between 'waaaa' , 'wzzzz') group      a.objective   when merge table , add narration field (ob_narr5) rows of data reduced ob_narr5 not exist every objective, see sql.      select a.objective, sum ( a.t_value ), b.ob_narr5     db2adm2.tfintr10 inner join db2adm2.tfinobjp b on b.ob_12345 = a.          objective     (a."year" =10)     , a.objective between 'waaaa' , 'wzzzz'     group a.objective, b.ob_narr5  rows returned 4.  how can return rows including blank fields , / or return rows blank fields? 

thanks replies, left , full outer join both work.

how replace <null> blank instead please?  waaaa   -173597.12  <null> wabaa   222717.76   general                          

you can use full outer join preserving values both tables or left outer join particular table


Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -