podoc:view_scanner_type_sql_view
Database View Description of "view_scanner_type"
Name
view_scanner_type
Description
Purpose
Schema
CREATE VIEW view_scanner_type AS SELECT scanner_type.identifier, manufacturer.name, model, variation, manufacturer.url FROM scanner_type, manufacturer WHERE scanner_type.manufacturer = manufacturer.identifier ORDER BY manufacturer.name, model, variation;
Related tables
History
Used first
Version 2.5
Used last
Still in use
Change history
= Version 2.5 =
create view view_scanner_type as select scanner_type.identifier, manufacturer.name, model, variation, manufacturer.url from scanner_type, manufacturer where scanner_type.manufacturer = manufacturer.identifier order by manufacturer.name, model, variation;
podoc/view_scanner_type_sql_view.txt · Last modified: 2007/04/23 14:21 by Luud