Project

General

Profile

« Previous | Next » 

Revision 13034

Added by Aaron Marcuse-Kubitza almost 11 years ago

validation/aggregating/specimens/qualitative_validations_specimens.sql: removed extra ; at ends of queries

View differences:

trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
58 58 
FROM taxonverbatim
59 59 
JOIN taxonlabel USING (taxonlabel_id)
60 60 
WHERE taxonverbatim.source_id = (SELECT source_by_shortname('NY'))
61 
AND genus IS NOT NULL;
61 
AND genus IS NOT NULL
62 62 
;
63 63 

  		




  64
  64
  
    
CREATE VIEW _specimens_09_list_of_unique_verbatim_author_taxa_with_genus AS


  		




  ......




  66
  66
  
    
FROM taxonverbatim


  		




  67
  67
  
    
JOIN taxonlabel USING (taxonlabel_id)


  		




  68
  68
  
    
WHERE taxonverbatim.source_id = (SELECT source_by_shortname('NY'))


  		




  69
  
  
    
AND genus IS NOT NULL;


  		




  
  69
  
    
AND genus IS NOT NULL


  		




  70
  70
  
    
;


  		




  71
  71
  
    

  		




  72
  72
  
    
CREATE VIEW _specimens_10_count_number_of_records_by_institution AS


  		












Also available in:  Unified diff