retrieve columns from sqlite3
- by John Smith
I have two tables in sqlite:
CREATE TABLE fruit ('fid' integer, 'name' text);
CREATE TABLE basket ('fid1' integer, 'fid2' integer, 'c1' integer, 'c2' integer);
basket is supposed to have count c1 of fruit fid1 and c2 of fruit fid2
I created a view fruitbasket;
create view fruitbasket as select * from basket inner join fruit a on…
