I am not sure if I understand your question correctly. This could be a simple inner join on the three matching columns. Also it matters when you say the rest doesn't match or the rest doesn't matter. If its the first one, you could need to compare(<>) each column to ensure they don't match .