Hi Victor, On Mon, Dec 5, 2016 at 6:16 PM, Anita Graser <[email protected]> wrote:
> Thanks Victor! > > On Mon, Dec 5, 2016 at 1:54 PM, Victor Olaya <[email protected]> wrote: > >> Anita, Mathieu >> >> I added both of your requests and it should be possible now to use >> tables on both "execute SQL" and "build virtual vector" algorithms >> >> Let me know if you try it (it is on master) > > > The SQL statement I want to execute (and which runs well in Layer | Add > Layer | Add Virtual Layer) is: > > select s_out.y1_statefips, s_out.y2_statefips, > st_centroid(f.geometry) > from fips as f > join stateoutflow1415 as s_out > on f.fips = s_out.y1_statefips > Which Processing tool should I use to create a layer from the above statement? Thank you and best wishes, Anita
_______________________________________________ Qgis-developer mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
