User Tools

Site Tools


podoc:view_lens_type_sql_view

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
podoc:view_lens_type_sql_view [2007/10/19 16:12]
Luud
podoc:view_lens_type_sql_view [2007/10/19 16:13] (current)
Luud
Line 12: Line 12:
  
 <code sql> <code sql>
-create view view_lens_type as select lens_type.identifier, ​ +create view view_lens_type as select lens_type.identifier,​ manufacturer.name,​
-manufacturer.name,​+
         model, variation, s_min_aperture,​ s_max_aperture,​         model, variation, s_min_aperture,​ s_max_aperture,​
-        s_min_focal_length,​ s_max_focal_length,​ manufacturer.url+        s_min_focal_length,​ s_max_focal_length,​ manufacturer.url
 +        exiftool_lens_id
     from lens_type, manufacturer,​     from lens_type, manufacturer,​
          ​(select identifier as identifier, value as s_min_focal_length          ​(select identifier as identifier, value as s_min_focal_length
podoc/view_lens_type_sql_view.txt · Last modified: 2007/10/19 16:13 by Luud