SELECT DISTINCT aa.arrest_id, NULL, aa.ID, 'ARR', aa.keyword, aa.date_of_info, aa.attachment_desc, a.file_type FROM arrest_attachments aa, attachments a WHERE aa.ID = a.ID UNION SELECT DISTINCT fia.fldint_id, NULL, fia.ID, 'FLDINT', fia.keyword, fia.date_of_info, fia.attachment_desc, a.file_type FROM field_interview_attachments fia, attachments a WHERE fia.ID = a.ID UNION SELECT DISTINCT pa.property_id, NULL, pa.ID, 'PRO', pa.keyword, pa.date_of_info, pa.attachment_desc, a.file_type FROM property_attachments pa, attachments a WHERE pa.ID = a.ID UNION SELECT DISTINCT ba.business_number, NULL, ba.ID, 'BUS', ba.keyword, ba.date_of_info, ba.attachment_desc, a.file_type FROM business_attachments ba, attachments a WHERE ba.ID = a.ID UNION SELECT DISTINCT va.vehicle_id, NULL, va.ID, 'VEH', va.keyword, va.date_of_info, va.attachment_desc, a.file_type FROM vehicle_attachments va, attachments a WHERE va.ID = a.ID UNION SELECT DISTINCT ea.ejs_emp_id, NULL, ea.ID, 'EMP', ea.keyword, ea.date_of_info, ea.attachment_desc, a.file_type FROM employee_attachments ea, attachments a WHERE ea.ID = a.ID UNION SELECT DISTINCT pa.person_id, NULL, pa.att_id, 'PER', pa.keyword, pa.date_of_info, pa.attachment_desc, a.file_type FROM person_attachments pa, attachments a WHERE pa.att_id = a.ID UNION SELECT DISTINCT ka.k9_id, NULL, ka.att_id, 'K9', ka.keyword, ka.date_of_info, ka.attachment_desc, a.file_type FROM k9_attachments ka, attachments a WHERE ka.att_id = a.ID UNION SELECT DISTINCT ca.citation_id, NULL, ca.att_id, 'CIT', ca.keyword, ca.date_of_info, ca.attachment_desc, a.file_type FROM citation_attachments ca, attachments a WHERE ca.att_id = a.ID UNION SELECT DISTINCT ga.gang_id, NULL, ga.att_id, 'GNG', ga.keyword, ga.date_of_info, ga.attachment_desc, a.file_type FROM gang_attachments ga, attachments a WHERE ga.att_id = a.ID UNION SELECT DISTINCT aa.address_id, NULL, aa.ID, 'ADDR', aa.keyword, aa.date_of_info, aa.attachment_desc, a.file_type FROM address_attachments aa, attachments a WHERE aa.ID = a.ID