Is there a way to do an advanced search and join 2 tables? I need all estimates with an opportunity with year of service 2019. An opportunity can have multiple years of service

This isnt too complicated...what is the information that isnt easy to come by...If you search Opportunities the related Estimates are tied to them...

@screnshaw how are your years of service setup? are they on the line items, in a joined Table? A field on the Opp? How is that setup?

@Sean Murphy the opportunity has a custom record that can have multiple years. so an opportunity can have multiple estimates and years.

try doing this as an opportunity search and joining on the Estimate Fields.... selection and the service year fields... should give you want. Because the opportunity is in the middle and linked to both you can accomplish both joins.