Dohvaćanje imena, prezimena, email adrese i države svih aktivnih zaposlenika i vanjskih suradnika

SELECT
  trim(trim(e.lname) || ' ' || trim(e.name)) AS fullname,
  trim(e.email),
  lc.country,
  lc.countrycode
FROM hemployees AS e
  LEFT OUTER JOIN legalchart_hstructure AS lc ON e.legal=lc.code
WHERE
  e.active=1 AND
  (
    e.facility IS NULL OR
    e.facility='C'
  ) AND
  trim(coalesce(e.email,''))<>'' AND
  trim(coalesce(e.lname,''))<>''
ORDER BY
  countrycode,
  fullname
;

Dohvaćanje imena, prezimena, kompanije i email adrese svih aktivnih zaposlenika i vanjskih suradnika

SELECT
  emplid,
  companycode,
  trim(trim(lname) || ' ' || trim(name)) AS fullname,
  email
FROM hemployees
WHERE
  active=1 AND
  (
    facility IS NULL OR
    facility='C'
  ) AND
  trim(coalesce(email,''))<>'' AND
  trim(coalesce(lname,''))<>''
;

Dohvaćanje šifri i naziva kompanija za gornje ljude

SELECT
  code,
  name
FROM legalchart_hstructure
WHERE
  code IN (
    SELECT DISTINCT
      companycode
    FROM hemployees
    WHERE
      active=1 AND
      (
        facility IS NULL OR
        facility='C'
      ) AND
      trim(coalesce(email,''))<>'' AND
      trim(coalesce(lname,''))<>''
  )
;