SELECT dbo.v_R_System.Name0, dbo.v_GS_SMXLOCALADMINSMIF.Account0, dbo.v_R_System.Operating_System_Name_and0
FROM dbo.v_R_System INNER JOIN
dbo.v_GS_SMXLOCALADMINSMIF ON dbo.v_R_System.ResourceID = dbo.v_GS_SMXLOCALADMINSMIF.ResourceID
WHERE (dbo.v_R_System.Operating_System_Name_and0 LIKE '%workstation%')