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