this is an output from my left join. Now all i want is to select only the user where the downline is not null.so it means that i want show sample1 and sample2 from my view. I tried to use the != null but it gaves me 0. Can you help me guys?