I have this SQL question
select sum(Antal_Best) as antalBest, sum(Antal_Lev) as antalLev, Artikel_Nr
from TreN_order where Order_Datum = '2008-08-05'
and artikel_Nr IN(010,012,013,014,015,018,110,130)
group by artikel_nr order by Artikel_Nr
I want it to always return the numbers of rows that are in the IN(**) and if thats empty it shall return 0 for the value.
If for example 010 and 012 have no data then my question will only return 6 rows, but I want it to return
8 rows all the time.