[Aust-NZ] Single to multiple joins

[Ben Caradoc-Davies]

David, Grant *did* mention locations, so there is a spatial component.  :-)

Grant, what is the feature and what are its attributes? The simplest 
model I could think of is each booth+candidate is a feature. WFS filter 
query to select.

What are the schemas of your tables? A view of an inner join should do 
the trick.

Kind regards,
Ben.

On 11/07/16 10:56, David Crisp wrote:
> Hi Grant,
>
> This probably isnt the correct mailing list to ask for SQL join
> questions.
>
> Your question appesr to be asking how to join tabular data sets together so
> you can analyse them and does not appear ot have a spatial data component.
>
> Sorry,   (Trying to not be THAT guy)
> David
>
>
>
> On Sun, Jul 10, 2016 at 2:15 PM, Grant Boxer <boxerg at iinet.net.au> wrote:
>
>> I am putting together election results for our recent election and I have
>> a located file of polling booths and a table of results. The problem I am
>> having is joining the 4 or 5 results per booth to the polling place
>> locations. My aim is to have a pie plot of percentage votes per
>> candidate/party by polling booth. I have tried joining tables but cannot
>> get the multiple results per booth for some reason. Any assistance
>> appreciated as I am probably doing it wrong!
>>
>> Cheers Grant
>>
>>
>>
>> Grant Boxer
>>
>> Perth, Western Australia
>>
>> _______________________________________________
>> Aust-NZ mailing list
>> Aust-NZ at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/aust-nz
>>
>
>
>
> _______________________________________________
> Aust-NZ mailing list
> Aust-NZ at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/aust-nz
>

-- 
Ben Caradoc-Davies <ben at transient.nz>
Director
Transient Software Limited <http://transient.nz/>
New Zealand