Subject Re: [firebird-support]Semantic Data Model was Derived tables
Author Mark Rotteveel
> There's overlap between table inheritance and derived tables (views):
> using
> views to achieve table inheritance.

Views are views, derived tables are select statements in the from clause, eg:
SELECT *
FROM (SELECT field1, field2 FROM tableX WHERE somecondition)

Views can be used to eliminate derived table from a query, or the other way around, derived table can be used to eliminate the need for (some) views. Depending on your usage pattern (and complexity of your views/derived tables).

Mark
--
Preisknaller: GMX DSL Flatrate für nur 16,99 Euro/mtl.!
http://portal.gmx.net/de/go/dsl02