Hi guys, I am trying to do a SQL statement fo this matter:
I need to return 1 (for true) if in my table user_tables I got for my column isJoin the count of 6 .
in addition to the count, I need check there is no value of 0 on that column. Example:
IsJoin: 1 2 3 0 0 4
Count = 6 , but got 2 zero, So i would return false.
IsJoin : 1 2 3 4 5 6
count = 6, no zero: Return true.
I didnt find the way to do it in SQl.. can you help ?