oracle - SQL : don't show columns with non data -


i have sql output this

t1.column1   t1.column2   t2.column3  t2.column4 ...  #1blabla     blabla       blabla      blabla .. #2blabla     blabla                   blabla .. 

i write sql statement shows rows have data in column3.

in case, row #2 should not shown.

any ideas?

i got far:

select *     table1 t1, table2 t2     t1.id = t2.id 

use is not null!

select * table1 t1   join table2 t2 on t1.id = t2.id t2.column3 not null; 

re-wrote modern join syntax.


Comments

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -