Sample SOQL:

SELECT Id FROM Attachment WHERE ParentId IN ( SELECT Id FROM Account )

The above SOQL fetches all the attachments ids from Account object.

Cheers!!!