SQLite does things quite differently than most mainstream SQL database engines ... I can simply change my create table statement as follows: Although it appears as if the table has no primary or ...

The third sub-language in SQL declares queries, through the SELECT statement and relational ... art is choosing a good, unique primary key for every table. You not only have to consider the ...

Since no primary key is set on a view, it simply took the first column in the table. The problem here should now be obvious, the first column is clearly not unique.