view_support_type
CREATE VIEW view_support_type AS SELECT support_type.identifier, manufacturer.name, model, variation, manufacturer.url FROM support_type, manufacturer WHERE support_type.manufacturer = manufacturer.identifier ORDER BY manufacturer.name, model, variation;
Version 2.5
Still in use
= Version 2.5 =
CREATE VIEW view_support_type AS SELECT support_type.identifier, manufacturer.name, model, variation, manufacturer.url FROM support_type, manufacturer WHERE support_type.manufacturer = manufacturer.identifier ORDER BY manufacturer.name, model, variation;