On 8 Jan 2017, at 12:46pm, Gan Uesli Starling <g...@starling.us> wrote:
> But it seems theres no way to make that a single, all-in-one-go kind of query.
Are you aware of SELECT … JOIN … ?
SELECT state.this,country.that FROM state
JOIN country ON country.name = state.country
WHERE state.name = "Washington"
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
