i need to make union query combine 3 different tables but in the same structure first one is the main and got relation with other two tables which are junction tables connected with its ID , then i want a dynamic row number changing based on any filter i provide, the problem is the the record in the 1st table could be duplicated in the junction tables so no row number method i found working correctly here,, i will be grateful if you can help me or show me another path to combine those 3 tables