podoc:view_flash_type_sql_view
Differences
This shows you the differences between two versions of the page.
Last revisionBoth sides next revision | |||
podoc:view_flash_type_sql_view [2007/04/12 12:23] – created Luud | podoc:view_flash_type_sql_view [2007/04/13 07:48] – Luud | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Database View Description ===== | + | ===== Database View Description |
=== Name === | === Name === | ||
+ | |||
+ | view_flash_type | ||
=== Description === | === Description === | ||
Line 9: | Line 11: | ||
=== Schema === | === Schema === | ||
- | === Related tables=== | + | create view view_flash_type as |
+ | select flash_type.identifier, | ||
+ | from flash_type, manufacturer | ||
+ | where flash_type.manufacturer | ||
+ | order by manufacturer.name, | ||
- | === Related | + | === Related |
+ | |||
+ | * [[flash_type sql table|flash_type]] | ||
+ | * [[manufacturer sql table|manufacturer]] | ||
=== Related indexes === | === Related indexes === | ||
=== Related functions === | === Related functions === | ||
+ | |||
+ | === Related views === | ||
=== History === | === History === | ||
Line 31: | Line 42: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | create view ... ( | + | create view view_flash_type as |
- | ... | + | select flash_type.identifier, manufacturer.name, model, variation, manufacturer.url |
- | ); | + | from flash_type, manufacturer |
+ | where flash_type.manufacturer = manufacturer.identifier | ||
+ | order by manufacturer.name, |
podoc/view_flash_type_sql_view.txt · Last modified: 2007/04/20 15:43 by Luud