Revision 12605
Added by Aaron Marcuse-Kubitza over 10 years ago
| 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