Project

General

Profile

« Previous | Next » 

Revision 1156

Added by Aaron Marcuse-Kubitza over 12 years ago

inputs/SALVIAS/verify.sql: Updated for schema changes

View differences:

verify.sql
21 21 
SELECT '1st methods' AS ___;
22 22 
SELECT DISTINCT
23 23 
    projectname AS project
24 
    , plotmethod.name AS method
24 
    , method.name AS method
25 25 
FROM project
26 26 
JOIN locationevent USING (project_id)
27 
JOIN plotmethod USING (plotmethod_id)
27 
JOIN method USING (method_id)
28 28 
ORDER BY project, method
29 29 
LIMIT 10;
30 30 

  		




  ......




  34
  34
  
    
    , method.observationmeasure AS observationmeasure


  		




  35
  35
  
    
FROM project


  		




  36
  36
  
    
JOIN locationevent USING (project_id)


  		




  37
  
  
    
JOIN plotmethod USING (plotmethod_id)


  		




  38
  37
  
    
JOIN method USING (method_id)


  		




  39
  38
  
    
ORDER BY project, observationmeasure


  		




  40
  39
  
    
LIMIT 10;


  		












Also available in:  Unified diff