SQL Report with the systems Names and Architecture for specific collection

finding the systems Names and Architecture for specific collection   SELECT     dbo.v_Collection.CollectionID, dbo.v_GS_COMPUTER_SYSTEM.Name0, dbo.v_GS_COMPUTER_SYSTEM.SystemType0,                       dbo.v_GS_COMPUTER_SYSTEM.UserName0, dbo.v_R_System.Operating_System_Name_and0FROM         dbo.v_Collection INNER JOIN                      […]