On Monday 16 July 2007 14:22, Slawomir Cichy wrote: > Hi Stefan > > Simply: > > create or replace view concat_eg > as > select field_1, field_2 from table > union all > select field_1, field_3 from table dziękuję (I vaguely remember UNION, now I finally know what it is for) -- Stefan Kuhn BSc MA IPB Halle AG Bioinformatik & Massenspektrometrie Weinberg 3 06120 Halle http://www.ipb-halle.de http://msbi.bic-gh.de skuhn@xxxxxxxxxxxx Tel. +49 (0) 345 5582 1474 Fax.+49 (0) 345 5582 1409 -- //www.freelists.org/webpage/oracle-l