Re: [SQL] using count in other column

Hello again, Le 25/07/09 0:41, nha a écrit : > Hello, > > Le 23/07/09 11:59, bartjoosen a écrit : >> Hi, >> >> I made up a query to make a count for each item for each month/year: >> SELECT"Artnr_ID", to_char("Date_plan","") AS "Jaar", >> to_char("Date_plan","MM") AS "Maand", Count("tblArtnrs

Re: [SQL] using count in other column

Hello, Le 23/07/09 11:59, bartjoosen a écrit : > Hi, > > I made up a query to make a count for each item for each month/year: > SELECT"Artnr_ID", to_char("Date_plan","") AS "Jaar", > to_char("Date_plan","MM") AS "Maand", Count("tblArtnrs"."Artikelnr") AS > "Monthly_count", "val1","val2","val3