Re: [GRASS-user] Advanced SQL Queries

2012-06-13 Thread Moritz Lennert
On 12/06/12 23:21, Rich Shepard wrote: Two tables: 'sites' contains the ID and geographic coordinates; 'waterchem' contains the ID and water chemistry data. The latter table is a sub-set of the former. I want to display only those sites for which chemistry data are available. In postgres I

Re: [GRASS-user] Advanced SQL Queries

2012-06-13 Thread Rich Shepard
On Wed, 13 Jun 2012, Moritz Lennert wrote: Just use everything after the first WHERE as argument for the 'where' parameter of d.vect (or any other module with a where parameter). Moritz, Thank you. Rich ___ grass-user mailing list

Re: [GRASS-user] Advanced SQL Queries

2012-06-13 Thread Micha Silver
On 06/13/2012 03:28 PM, Moritz Lennert wrote: On 12/06/12 23:21, Rich Shepard wrote: Two tables: 'sites' contains the ID and geographic coordinates; 'waterchem' contains the ID and water chemistry data. The latter table is a

[GRASS-user] Advanced SQL Queries

2012-06-12 Thread Rich Shepard
Two tables: 'sites' contains the ID and geographic coordinates; 'waterchem' contains the ID and water chemistry data. The latter table is a sub-set of the former. I want to display only those sites for which chemistry data are available. In postgres I write, SELECT DISTINCT(w.site)