truiz

SELECT --*
  'ARXEION',
  document.archive_id,
  to_char(document.data_creation, 'YYYY') as ANNO,
  to_char(document.data_creation, 'MONTH') as MESE,
  document.document_guid,
  document.file_name,
  CASE WHEN attachment.attachment_file_name IS NULL THEN NULL ELSE 'ATTACHMENTS' END AS ATTACHMENTS,
  attachment.attachment_file_name,
  archive_name,
  archive_location
FROM
  archive INNER JOIN document ON archive.id = document.archive_id
  LEFT OUTER JOIN document_in_attachment ON document.id = document_in_attachment.document_id
  LEFT OUTER JOIN attachment ON attachment.id = document_in_attachment.attachment_id