How to select a related group of items in Oracle SQL

Key    ID      Link
1      MASTER  123
2      AA      123
3      AA      123
4      BB      123
5      MASTER  456
6      CC      456

1      MASTER  123
2      AA      123
3      AA      123

SELECT DISTINCT key, id, link
  FROM the_table
  START WITH id = 'AA'
  CONNECT BY id = 'MASTER' and link = PRIOR link and 'AA' = PRIOR ID

select i.link from table i
where i.id = YOUR_ID

select * from table
where link in (select i.link from table i where i.id = YOUR_ID)