I am trying to write a query needed for a report. I first need to get the following data, which is working.
SELECT MachineID, Caption00, CSDVersion00, CountryCode00, Version00
Operating_System_DATA ON OPERATING_SYSTEM_EXT_DATA.MachineID = Operating_System_DATA.MachineID
WHERE OPERATING_SYSTEM_EXT_DATA.Name00 LIKE '%Server%'
I then need to run the following query on the results of the query above.
Select * FROM vSites WHERE ReportToSite = 'ABC'
I have tried nesting it and using an alias, but no luck so far. I then need to count the distinct captions and group by ReportToSite. I am a newbie and have been struggling with this all week. Any help would be appreciated.