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 revision Previous revision
podoc:view_film_type_sql_view [2007/04/16 11:44]
Luud
podoc:view_film_type_sql_view [2007/04/20 11: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 11:41 by Luud