Join the two index in the ElasticSearch to query the data with sorting

That's the best option though. If this theorical update happens once per year or has less than let say 10m events, I'd probably go that way.

Otherwise, have a look at Join field type | Elasticsearch Guide [7.16] | Elastic