Hi community,
I got a table with a foreign key in it. This table has another column named status.
Now I only want to get the record with the foreign key once, when all records with the foreign key have status = 'open'.
My Table as example:
| ID | A_ID | STATUS |
|---|
| 1 | 1 | Open |
| 2 | 1 | - |
| 3 | 2 | Open |
| 4 | 2 | Open |
Result I need:
I guess this is simple but I dont get it. Thanks!
Greetings