best way to join tables that have a column with the same intervals

I have two separate tables with data about a group of drill holes. I want to join them by matching the columns of hole ID, meter to and meter from. How can I best join these together?