Photo Organizer

view_support_type

CREATE VIEW view_support_type AS
  SELECT support_type.identifier, manufacturer.name, model, variation, manufacturer.url
    FROM support_type, manufacturer
   WHERE support_type.manufacturer = manufacturer.identifier
   ORDER BY manufacturer.name, model, variation;

• manufacturer
• support_type

Version 2.5

Still in use

= Version 2.5 =

CREATE VIEW view_support_type AS
  SELECT support_type.identifier, manufacturer.name, model, variation, manufacturer.url
    FROM support_type, manufacturer
   WHERE support_type.manufacturer = manufacturer.identifier
   ORDER BY manufacturer.name, model, variation;