values for columns using sql

**st0kvis** · 08-10-2011, 10:57 AM

i new to SQL say i have this:

SELECT sum(tonsharvested) as kaapstad2011
FROM T_harvest
where BlockNameID = "Kaapstad" and year(Dateofharvest) = "2011"

it gives me a column kaapstad2011 with sufficient values

why cant i just say

SELECT sum(tonsharvested) as kaapstad2010
FROM T_harvest
where BlockNameID = "Kaapstad" and year(Dateofharvest) = "2010"

to display kaapstad2010 next to column above?
Any advise on how to go further will help, cant seem to shift past this mental block.

**ConneXionLost** · 08-10-2011, 11:51 AM

Hi,

Give this a try:

SELECT Sum(IIf(Year([Dateofharvest])=2011,[tonsharvested],0)) AS kaapstad2011, Sum(IIf(Year([Dateofharvest])=2010,[tonsharvested],0)) AS kaapstad2010
FROM T_harvest
WHERE T_harvest.BlockNameID="Kaapstad";

Cheers,