For this scenaio, I would follow the below steps:
* Create a join view with the join condition set as "file-id" = "record-no" and remove the duplicate fields.
* In the **Group By** tab of the view, I would enable ‘Use group by’ and add the selection fields.
* In the **Output** tab, I would sort the view with the ‘order by desc’.
* Next, create a **New aggr. Field** using the max function for the field "version-no" and save the view.
For more information, you can take a look at the [Creating Join Views](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_derived_views/creating_join_views/creating_join_views#creating-join-views) and [MAX](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/aggregation_functions/aggregation_functions#max) documentation.
Additionally, if you still need help and if you are a user with valid support access then you can create a support case in [Denodo Support Site](https://support.denodo.com/) so that our support team will assist you further.
Hope this helps!