Revision 12605
Added by Aaron Marcuse-Kubitza over 10 years ago
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
fix: inputs/SALVIAS/validations.sql: _plots_18_list_of_subplots_codes_for_each_plot_for_each_project: changed columns to match output query