On 7 Jan 2017, at 10:54pm, Gan Uesli Starling <g...@starling.us> wrote:
> As for the suggestion to 'normalize' my four tables to one ... yes, I could > do that ... but it would make for a LOT of redundant data duplicated in > plural columns, which seems to me in my doubtless ignorant newbie status, as > missing the point for a database. The suggestion is that you that you retain your 'world' and 'country' tables, but merge all the 'state' tables together, adding a 'country' column. That way you don’t have to have different code to handle States of the USA, Provinces of Canada, States of Mexico, Couhties of England, Cantons of Switzerland, etc.. It will save a great deal of programming. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
