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 - How to save instance state of selected radiobutton on menu -

python 3 IndexError: list index out of range -

IF statement in MySQL trigger -