|Subject||Re: [firebird-support]Semantic Data Model was Derived tables|
> There's overlap between table inheritance and derived tables (views):Views are views, derived tables are select statements in the from clause, eg:
> views to achieve table inheritance.
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).
Preisknaller: GMX DSL Flatrate für nur 16,99 Euro/mtl.!