On 9/27/07, Stefan Schwarzer <[EMAIL PROTECTED]> wrote:
>
> I really tried it out. I changed my whole database to the "id-country | year
> | value" - format. And then tried to build my SQL queries. But it was
> really, really difficult, and sometimes impossible (for me) to get what I
> wanted.
>
>
I really tried it out. I changed my whole database to the "id-country
| year | value" - format. And then tried to build my SQL queries. But
it was really, really difficult, and sometimes impossible (for me) to
get what I wanted.
Actually, it remains quite difficult for me to remember the ac
Stefan Schwarzer wrote:
Sorry,
I forgot to mention my table design, which is like this:
name 20012002 2003 2004 2005
-
Afghanistan
Albania
(Yep, I know, bad table design :-)).
Sorry,
I forgot to mention my table design, which is like this:
name 20012002 2003 2004 2005
-
Afghanistan
Albania
(Yep, I know, bad table design :-)). I tried to change it to
If I understood your question, maybe it's you want:
SELECT min() FROM table1 JOIN table2 ON (table1.data_field=
table2.data_field);
2007/9/27, Stefan Schwarzer <[EMAIL PROTECTED]>:
>
> Hi there,
>
> my aim is to plot a line graph for a single country but for two or
> three variables. Now,
Hi there,
my aim is to plot a line graph for a single country but for two or
three variables. Now, one could use two different y-axis (if there
are two data sets with different units); but it's not really the
right way to analyse data.
One should rather normalize them to a base year to enhance
c
