Photo Organizer

view_film_type

CREATE VIEW view_film_type AS
  SELECT film_type.identifier, manufacturer.name, model, film_iso.VALUE AS iso, film_format.VALUE AS format, manufacturer.url
    FROM film_type, manufacturer, film_iso, film_format
   WHERE film_type.manufacturer = manufacturer.identifier
     AND film_type.iso = film_iso.identifier
     AND film_type.format = film_format.identifier
   ORDER BY manufacturer.name, model, film_iso.VALUE;

• film_format
• film_iso
• film_type
• manufacturer

Version 2.5

Still in use

= Version 2.5 =

CREATE VIEW view_film_type AS
  SELECT film_type.identifier, manufacturer.name, model, film_iso.VALUE AS iso, film_format.VALUE AS format, manufacturer.url
    FROM film_type, manufacturer, film_iso, film_format
   WHERE film_type.manufacturer = manufacturer.identifier
     AND film_type.iso = film_iso.identifier
     AND film_type.format = film_format.identifier
   ORDER BY manufacturer.name, model, film_iso.VALUE;

= Version 2.27 =

DROP VIEW view_film_type;
 
CREATE VIEW view_film_type AS
  SELECT film_type.identifier, manufacturer.name, model, film_iso.VALUE AS iso, film_format.VALUE AS format, manufacturer.url
    FROM film_type, manufacturer, film_iso, film_format
   WHERE film_type.manufacturer = manufacturer.identifier
     AND film_type.iso = film_iso.identifier
     AND film_type.format = film_format.identifier
   ORDER BY manufacturer.name, model, film_iso.VALUE;