Hey guys! I am relatively new to query building and have stumbled into a bit of an issue. I have taken two sets of data and united them where there are similarities with a union. My goal is to filter this data to only look at where there are duplicate ID's then further down to the ID with the Higher value hour meter. I can't seem to figure it out. Here is what I have successfully done so far. Thanks for any help in advance