A few more comments on your table design. Stefan Schwarzer skrev: > So, instead of the earlier mentioned database design, I would have > something like this: > > - one table for the country names/ids/etc. (Afghanistan, 1; Albania, > 2....) There is a well-established natural key for countries - ISO 3166. Use that instead of "id". > - one table for the variable names/ids/etc. (GDP, 1; Population, 2; > Fish Catch, 3;....) > - one table for the years names/ids/etc. (1970, 1; 1971, 2; 1973, 3; > ....) No need for an ID column on this one. Just use the year as the primary key. Nis ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
