My English is poor, please forgive me.
The first time I use SQLite database. I've read the full page instructions of JSON1, But I don't know how to use JSON1 to query multiple layers JSON data. The Data as follows : { id: 1, data: { customer: 1, goods: [ { id: 1, name: "apple", price: 12, num: 10, amount: 120 }, { id: 2, name: "perl", price: 10, num: 5, amount: 50 } ] } } { id: 2, data: { customer: 2, goods: [ { id: 1, name: "apple", price: 12, num: 10, amount: 120 }, { id: 2, name: "perl", price: 10, num: 5, amount: 50 }, { id: 3, name: "banana", price: 10, num: 5, amount: 50 } ] } } { id: 3, data: { customer: 2, goods: [ { id: 1, name: "apple", price: 12, num: 10, amount: 120 } ] } } How can I count the amount and num of goods when the customer or goods name is different. I only write the SQL: select json_extract(data, '$.goods') from table_name where customer = 2 When I got the data, I use the programming language to loop the results and add amount and num by myself. Can you help me, tell me how I should write this. And thanks for your help, your sqlite database is good database, I will continue to use it on my program. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users