SQL za dohvaćanje podataka iz P Connecta (ime, prezime, kompanija, e-mail)

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

SQL za "odrollavanje" 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,''))<>''
    )
  ;