Bare with me everyone!
I am new to my job role and struggling with something to which no one is around to assist!
Basically in the query I need a Collumn to only output the greatest value that is given within the sub query. If that makes sense?
Eg. Tenancy start date must be the highest...
