AmrelMahdy Posted February 14, 2013 Report post Posted February 14, 2013 Dears , I was making a Query on the Computers that have an application named "Vmcisockets" found in Add/remove programs , this could be found as a 32-bit Application or 64-Bit Application, when I make a Query as in the shown pic , I only got results for computers that have this application installed as 64-bit Only , computers that have this application installed as 32-bit application doesnt appear in the result , could anyone tell me whats wrong in this Query ?? Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted February 14, 2013 Report post Posted February 14, 2013 The problem is going to be related to you query and how you have the joins setup... You will need to use Left outer joins to solve this issue, you will need to do this on the Joins tab. Quote Share this post Link to post Share on other sites More sharing options...
AmrelMahdy Posted February 14, 2013 Report post Posted February 14, 2013 Thanks Garth , but sorry i didnt get your point below is a screen shot of the Joins tab Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted February 14, 2013 Report post Posted February 14, 2013 Look at the properties of the ARP64 line.. You will find that it say "Join" or "Inner Join", this needs to be changed to an "Outer join".. and by the looks of it a "Left outer join". I would write this for you but I'm sitting in lobby of my car dealer waiting for my car to be fixed. :-) Quote Share this post Link to post Share on other sites More sharing options...
AmrelMahdy Posted February 14, 2013 Report post Posted February 14, 2013 Hahaha Thanks Garth ,, waiting for your Reply ,, Also takecare When riding ur Car : Quote Share this post Link to post Share on other sites More sharing options...
AmrelMahdy Posted February 17, 2013 Report post Posted February 17, 2013 Gareth , I changed the ARP64 line'd join to left and it worked , but i dont get the idea of the joins and the difference between its types Quote Share this post Link to post Share on other sites More sharing options...
