Check if ANY rows from a subquery are IN another subquery

If I understand what you want, then

WHERE EXISTS (SELECT * FROM [file] 
   WHERE [file].userid = doc.userid 
      AND [file].userid IN (SELECT share.shareid from share where share.userid = '1234'))

Tom