Hi All
Ive got a table in the following format:
| ID | STATUS | Pending | Done |
|---|
| 1 | Pending | 1 | |
| 1 | Done | 1 | 1 |
| 2 | Done | | 1 |
| 3 | Pending | 1 | |
| 3 | Done | 1 | 1 |
| 4 | Peding | 1 | |
It means: In the beggining of the day, the pending activities are shown in the table and we will only have one row per ID (Status = Pending - like row number 1). If the activity is done, then another row of the same ID is created (like row number 2).
It is possible to do an activity that wasnt on the list in the begging of the day, so it will be shown in the table like row number 3 (ID = 2).
What I want is: A list of every activity that is pending in the begging of the day and was not done yet.
Thx in advance!
