Anonymous

SELECT p.navn, f.norsknavn, t.ANTALL 
  FROM (SELECT pid, max(antalla) antall 
          FROM (SELECT r.pid, o.fid, SUM(o.antall) antalla 
                  FROM observasjon o, rapportoer r 
                 WHERE r.oid = o.oid 
                 GROUP BY o.fid, r.pid 
                 ORDER BY pid) xx 
         GROUP BY xx.pid ) t, person p, ( SELECT r.pid, o.fid, SUM(o.antall) antallb 
                                                    FROM observasjon o, rapportoer r 
                                                   WHERE r.oid = o.oid 
                                                   GROUP BY o.fid, r.pid ) aa, fugl f 
 WHERE t.pid = p.pid
   AND aa.pid = t.pid 
   AND aa.fid = f.fid 
   AND t.antall = aa.antallb 
 ORDER BY navn