adjust query with another join
I need to add another join to the below query. When I look at the below query as is it looks like there is one too many joins. Can someone help?
SELECT vComputer.Name AS 'Computer Name', vComputer.[User] AS 'Primary Owner', vComputer.[OS Name], vCollection.Description
FROM CollectionMembership INNER JOIN
vComputer ON CollectionMembership.ResourceGuid = vComputer.Guid INNER JOIN
vCollection INNER JOIN
Collection ON vCollection.Guid = Collection.Guid ON CollectionMembership.CollectionGuid = Collection.Guid
where vCollection.Name = '.All Laptops'
ORDER BY [Computer Name]
The query actually works, even with what appears to be another unneeded join. I need to add in one for INNER JOIN vHWComputerSystem ON vComputer.Guid = vHWComputerSystem._ResourceGuid.
Should be easy enough. Just puzzled about the other join