Query to Find Parts with similar materials (1 Viewer)

Hello,

I need to come up with a query to find our products with similar materials, and i'm hitting a wall. Here is an example what my initial table looks like:


What i need to find is how many parts are similar to each other. So i need to know that sku1 and sku4 both have the same materials, but also that sku1 and sku2 share 2 materials, etc. So my results should look something like:


What i can think of is that i need to loop over each sku and find all similar skus, but i can't think of how to do this in a query, but all of my data are in tables. so i'm stuck. Anyone have any ideas? Thank you!!

You may find Allen Browne's concatenate function to be your friend - http://allenbrowne.com/func-concat.html

That looks promising - so are you saying to concatenate the values and then do the compare? That would get me the exact matches, but not those with partial matches - also would need to make sure the materials are ordered the same each time...

You probably need to make a couple of queries, one to join the table to a copy of itself by materials then feed that into the concatenate function.

I'm sorry - i'm still confused - what am i outputting from the first query where i'm joining the table to itself by materials?