...end MSSQL, men du ved - jo mindre haj, jo mindre abstraktionsevne, og jo mindre skridt i afprøvningen. SELECT ISNULL(b.theyear, p.theyear) as theYear, b.antal as bAntal, p.antal as pAntal FROM ( select year(oprettet) as theYear, count(*) as antal from banner where year(oprettet) < 2006 group by year(oprettet) ) b FULL OUTER JOIN ( select year(oprettet) as...

... det fint. Her er en fuld forespørgsel (med andre tabel/feltnavne - det kan du selv rette til): SELECT ISNULL(b.theyear, p.theyear) as theYear, b.antal as bAntal, p.antal as pAntal FROM ( select year(oprettet) as theYear, count(*) as antal from banner where year(oprettet) < 2006 group by year(oprettet) ) b FULL OUTER JOIN ( select year(oprettet) as theYear, count(*) as antal ...