User Tools

Site Tools


podoc:view_film_type_sql_view

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
podoc:view_film_type_sql_view [2007/04/16 15:44] Luudpodoc:view_film_type_sql_view [2007/04/20 15:41] (current) Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  create view view_film_type as +<code sql> 
-    select film_type.identifier, manufacturer.name, model, film_iso.value as iso, film_format.value as format, manufacturer.url +create view view_film_type as 
-      from film_type, manufacturer, film_iso, film_format +  select film_type.identifier, manufacturer.name, model, film_iso.value as iso, film_format.value as format, manufacturer.url 
-     where film_type.manufacturer = manufacturer.identifier +    from film_type, manufacturer, film_iso, film_format 
-       and film_type.iso = film_iso.identifier +   where film_type.manufacturer = manufacturer.identifier 
-       and film_type.format = film_format.identifier +     and film_type.iso = film_iso.identifier 
-     order by manufacturer.name, model, film_iso.value;+     and film_type.format = film_format.identifier 
 +   order by manufacturer.name, model, film_iso.value; 
 +</code>
  
 === Related tables === === Related tables ===
Line 25: Line 27:
   * [[film_type sql table|film_type]]   * [[film_type sql table|film_type]]
   * [[manufacturer sql table|manufacturer]]   * [[manufacturer sql table|manufacturer]]
- 
-=== Related indexes === 
- 
-=== Related functions === 
- 
-=== Related sequences === 
  
 === History === === History ===
Line 46: Line 42:
 = Version 2.5 = = Version 2.5 =
  
-  create view view_film_type as +<code sql> 
-    select film_type.identifier, manufacturer.name, model, film_iso.value as iso, film_format.value as format, manufacturer.url +create view view_film_type as 
-      from film_type, manufacturer, film_iso, film_format +  select film_type.identifier, manufacturer.name, model, film_iso.value as iso, film_format.value as format, manufacturer.url 
-     where film_type.manufacturer = manufacturer.identifier +    from film_type, manufacturer, film_iso, film_format 
-       and film_type.iso = film_iso.identifier +   where film_type.manufacturer = manufacturer.identifier 
-       and film_type.format = film_format.identifier +     and film_type.iso = film_iso.identifier 
-     order by manufacturer.name, model, film_iso.value;+     and film_type.format = film_format.identifier 
 +   order by manufacturer.name, model, film_iso.value; 
 +</code>
  
 = Version 2.27 =  = Version 2.27 = 
  
-<code>+<code sql>
 drop view view_film_type; drop view view_film_type;
  
podoc/view_film_type_sql_view.txt · Last modified: 2007/04/20 15:41 by Luud