User Tools

Site Tools


podoc:view_flash_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_flash_type_sql_view [2007/04/13 03:48]
Luud
podoc:view_flash_type_sql_view [2007/04/20 11:43] (current)
Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  ​create view view_flash_type as +<code sql> 
-    select flash_type.identifier,​ manufacturer.name,​ model, variation, manufacturer.url +create view view_flash_type as 
-      from flash_type, manufacturer +  select flash_type.identifier,​ manufacturer.name,​ model, variation, manufacturer.url 
-     ​where flash_type.manufacturer = manufacturer.identifier +    from flash_type, manufacturer 
-     ​order by manufacturer.name,​ model, variation;+   ​where flash_type.manufacturer = manufacturer.identifier 
 +   ​order by manufacturer.name,​ model, variation; 
 +</​code>​
  
 === Related tables === === Related tables ===
Line 21: Line 23:
   * [[flash_type sql table|flash_type]]   * [[flash_type sql table|flash_type]]
   * [[manufacturer sql table|manufacturer]]   * [[manufacturer sql table|manufacturer]]
- 
-=== Related indexes === 
- 
-=== Related functions === 
- 
-=== Related views === 
  
 === History === === History ===
Line 42: Line 38:
 = Version 2.5 = = Version 2.5 =
  
-  ​create view view_flash_type as +<code sql> 
-    select flash_type.identifier,​ manufacturer.name,​ model, variation, manufacturer.url +create view view_flash_type as 
-      from flash_type, manufacturer +  select flash_type.identifier,​ manufacturer.name,​ model, variation, manufacturer.url 
-     ​where flash_type.manufacturer = manufacturer.identifier +    from flash_type, manufacturer 
-     ​order by manufacturer.name,​ model, variation;+   ​where flash_type.manufacturer = manufacturer.identifier 
 +   ​order by manufacturer.name,​ model, variation; 
 +</​code>​
  
podoc/view_flash_type_sql_view.txt · Last modified: 2007/04/20 11:43 by Luud