Re: [sqlite] raising constraint violations when using SELECT DISTINCT with multiple tables

Quoth gc , on 2010-10-16 03:37:15 -0400: > CREATE TABLE Code_Units("code", "unit", PRIMARY KEY ("code")); > CREATE TABLE Base_Data_1 ("partner", "code", "unit", "value", PRIMARY KEY > ("partner", "code")); [...] I might consider doing something like this (untested):

[sqlite] raising constraint violations when using SELECT DISTINCT with multiple tables

As a first-time poster may I be forgiven a very basic (yet somewhat long) question? I'm using SQLite with a relatively large (+100GB, 1.7 billion records and growing) dataset. It's working wonderfully, in part because I've kept the data separated on a natural key into about 250 individual