Forum Discussion
Solved
Remove specific rows in Query under conditions
The data in the left side of the table is what i have, i want to remove "sections" that are "0", however there are "cat" with all "section" equals to "0", and i would like to keep this "cat" as shown in the right side of the table.
| cat | section | T/F | cat | section | T/F | |
| 1 | A | 1 | 1 | A | 1 | |
| 1 | B | 0 | 2 | D | 1 | |
| 1 | C | 0 | 3 | null | null | |
| 1 | D | 0 | 4 | null | null | |
| 2 | A | 0 | 5 | null | null | |
| 2 | B | 0 | 6 | null | null | |
| 2 | C | 0 | 7 | any of the letter | 0 | |
| 2 | D | 1 | ||||
| 3 | null | null | ||||
| 4 | null | null | ||||
| 5 | null | null | ||||
| 6 | null | null | ||||
| 7 | A | 0 | ||||
| 7 | B | 0 | ||||
| 7 | C | 0 | ||||
| 7 | D | 0 |
