Differences

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

--- podoc:view_lens_type_sql_view [2007/10/19 20:12] – Luud
+++ podoc:view_lens_type_sql_view [2007/10/19 20:13] (current) – Luud
@@ Line 12: / Line 12: @@
 <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,
-        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,
          (select identifier as identifier, value as s_min_focal_length