I have a single table (Tracker) containing 2 columns; (ID and Status). I would like to retrieve a list of ID's without the status approved, however a status can go from pending to approve and the original data will not be removed. See below example and desired outcome.
Tracker Table:
ID |
Status |
123 |
Pending |
123 |
Approved |
456 |
Pending |
678 |
Denied |
894 |
Approved |
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…