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;
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;