Re: [GENERAL] Problem with Crosstab - Allocating value to wrong column

2010-10-19 Thread Joe Conway
On 10/19/2010 03:07 AM, Stefan Schwarzer wrote: > For one of the countries, I have a value for 2007, but not for 1960. > When using only the inner query, than I see one line: Andorra - 2007 > - 539 But when running the whole SQL, the value for year 2007 get's > allocated to the year 1960. The tabl

[GENERAL] Problem with Crosstab - Allocating value to wrong column

2010-10-19 Thread Stefan Schwarzer
Hi there, I have a database with statistical tables which look like this: id|year_start |value 3 1960 736.1 3 1961 723.3 4 1960 123.4 Years can cover 40 years for each of the countries (ID) and each (v