SELECT *
FROM person Person, subcontractor Subcontractor, attach_doc AttachDoc, vo_document_type VoDocumentType
WHERE Person.RANK1_SC_TIN = Subcontractor.COMPANY_TIN
AND AttachDoc.SUBCONTRACTOR_ID = Subcontractor.SUBCONTRACTOR_ID
AND AttachDoc.vo_document_type_id = VoDocumentType.vo_document_type_id
AND VoDocumentType.document_type_id = 102;