select
v_R_System.ResourceID,
v_R_System.Name0,
v_R_System.Client0

from

v_R_System

where

v_R_System.ResourceID in (
  select 
    v_GS_ADD_REMOVE_PROGRAMS.ResourceID
  from
    v_GS_ADD_REMOVE_PROGRAMS
  where
    v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 = 'Google Chrome'
            )
or v_R_System.ResourceID in (
  select 
    v_GS_ADD_REMOVE_PROGRAMS_64.ResourceID
  from
    v_GS_ADD_REMOVE_PROGRAMS_64
  where
    v_GS_ADD_REMOVE_PROGRAMS_64.DisplayName0 = 'Google Chrome'
            )