Project

General

Profile

« Previous | Next » 

Revision 12605

fix: inputs/SALVIAS/validations.sql: _plots_18_list_of_subplots_codes_for_each_plot_for_each_project: changed columns to match output query

View differences:

trunk/inputs/SALVIAS/validations.sql
343 343
CREATE VIEW _plots_18_list_of_subplots_codes_for_each_plot_for_each_project AS
344 344
 SELECT DISTINCT p.project_name, 
345 345
    (pm."SiteCode")::text AS plot_code, 
346
    po."Line" AS subplot
346
    po."Line" AS subplot_code
347 347
   FROM ((projects p
348 348
   JOIN "plotMetadata" pm ON ((p.project_id = pm.project_id)))
349 349
   JOIN "plotObservations" po ON (((pm."PlotID" = po."PlotID") AND ((pm."SiteCode")::text IS NOT NULL))))

Also available in: Unified diff