Subject | Re: [firebird-support]Semantic Data Model was Derived tables |
---|---|
Author | Mark Rotteveel |
Post date | 2009-12-03T07:35:05Z |
> There's overlap between table inheritance and derived tables (views):Views are views, derived tables are select statements in the from clause, eg:
> using
> views to achieve table inheritance.
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