Project

General

Profile

« Previous | Next » 

Revision 14861

Added by Aaron Marcuse-Kubitza about 10 years ago

schemas/public_.sql: view_full_occurrence_individual_view: join to taxonoccurrence: can use a USING join for this because plot.** only exports one locationevent_id column

View differences:

trunk/schemas/public_.sql
12112 12112 
    aggregateoccurrence.count AS individual_count,
12113 12113 
    plantobservation.plantobservation_id
12114 12114 
   FROM ((((((((((((("plot.**"
12115 
   LEFT JOIN taxonoccurrence ON ((taxonoccurrence.locationevent_id = "plot.**".locationevent_id)))
12115 
   LEFT JOIN taxonoccurrence USING (locationevent_id))
12116 12116 
   LEFT JOIN party collector ON ((collector.party_id = taxonoccurrence.collector_id)))
12117 12117 
   LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id))
12118 12118 
   LEFT JOIN plantobservation USING (aggregateoccurrence_id))
trunk/schemas/vegbien.sql
12112 12112 
    aggregateoccurrence.count AS individual_count,
12113 12113 
    plantobservation.plantobservation_id
12114 12114 
   FROM ((((((((((((("plot.**"
12115 
   LEFT JOIN taxonoccurrence ON ((taxonoccurrence.locationevent_id = "plot.**".locationevent_id)))
12115 
   LEFT JOIN taxonoccurrence USING (locationevent_id))
12116 12116 
   LEFT JOIN party collector ON ((collector.party_id = taxonoccurrence.collector_id)))
12117 12117 
   LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id))
12118 12118 
   LEFT JOIN plantobservation USING (aggregateoccurrence_id))

Also available in: Unified diff