2
I have a table of technical calls and a table of appointments. Each 'CALL' has several 'CALLS' and it is in the calls that is the field that defines the status of the call (Open, Closed, In progress, Suspended, etc...)
Currently, when I need to list only open calls, I am seeking ALL calls and for each call I make a new query checking whether the last call is closed or not. This practice is not correct. How can I, in a single query, search only the calls in which the last answer is not CLOSED?
What are your table relation fields? Call nº 5 service º 45
– Silvio Andorinha