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
Post a Comment