How to filter based on all computer values of a column? Or multiple joins?

%3CLINGO-SUB%20id%3D%22lingo-sub-1771690%22%20slang%3D%22en-US%22%3EHow%20to%20filter%20based%20on%20all%20computer%20values%20of%20a%20column%3F%20Or%20multiple%20joins%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1771690%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CBR%20%2F%3EI'm%20using%20a%20query%20that%20joins%20two%20perf%20counters%20in%20one%20table%2C%20based%20on%20the%20Computer%20name.%3CBR%20%2F%3EI%20started%20to%20think%20on%20how%20to%20add%20a%20third%20counter%20and%20join%20it%20to%20the%20same%20table%20on%20the%20same%20query%2C%20and%20I%20wondered%20if%20it%20wouldn't%20be%20more%20efficient%20to%20restrict%20the%20results%20beforehand%20instead%20of%20doing%20a%20join%20of%20all%20results.%3CBR%20%2F%3ESo%20that%20would%20mean%20bringing%20the%20perf%20counters%20where%20Computer%20%3D%3D%20%22Computer%20names%20values%20that%20are%20on%20the%20Computer%20column%20of%20the%20previous%20table%22%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20that%20possible%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAnd%2C%20if%20not%2C%20how%20can%20I%20join%20more%20than%20two%20tables%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1771690%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELog%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMetrics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuery%20Language%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1795135%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20filter%20based%20on%20all%20computer%20values%20of%20a%20column%3F%20Or%20multiple%20joins%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1795135%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F104993%22%20target%3D%22_blank%22%3E%40Dante%20Nahuel%20Ciai%3C%2FA%3E%26nbsp%3BI%20don't%20understand%20what%20exactly%20you%20want%20to%20do.%20Can%20you%20share%20your%20query%2C%20or%20what%20exactly%20you%20want%20to%20query%3F%3C%2FP%3E%0A%3CP%3EYou%20can%20of%20course%20join%20over%20another%20join%2C%20but%20it%20sounds%20less%20efficient.%20More%20details%20would%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi
I'm using a query that joins two perf counters in one table, based on the Computer name.
I started to think on how to add a third counter and join it to the same table on the same query, and I wondered if it wouldn't be more efficient to restrict the results beforehand instead of doing a join of all results.
So that would mean bringing the perf counters where Computer == "Computer names values that are on the Computer column of the previous table"

Is that possible?

And, if not, how can I join more than two tables?

Thanks in advance

1 Reply

@Dante Nahuel Ciai I don't understand what exactly you want to do. Can you share your query, or what exactly you want to query?

You can of course join over another join, but it sounds less efficient. More details would help.