> On Dec 19, 2019, at 7:45 PM, No.1 Perfect <757171...@qq.com> wrote: > > How can I count the amount and num of goods when the customer or > goods name is different.
Querying the contents of arrays is kind of complicated. SQL doesn't understand arrays, so the query has to use a "table-valued function", json_each, that makes the array appear to be a table where each item is a row. Then you can use a JOIN to query that "table". The documentation has examples: https://sqlite.org/json1.html#jeach <https://sqlite.org/json1.html#jeach> —Jens PS: Your email program is turning nonbreaking spaces into " ", which makes your message hard to read. Please try to fix that. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
