Re: select über mehrere tabellen
Posted by:
Peter T
Date: June 25, 2009 09:38AM
danke, und geht das auch mit dem syntax, ich bekomme es nicht hin?
SELECT DATUM, PNR, KST, SUM( STD ) from tabelle1 UNION [All] SELECT DATUM, PNR, KST, SUM( STD ) from tabelle 2UNION [All] WHERE DATUM LIKE 2009-06 AND BM < 1000 GROUP BY DATUM, PNR, KST, STD WITH ROLLUP
Subject
Views
Written By
Posted
7412
June 22, 2009 10:16AM
3786
June 22, 2009 10:38AM
Re: select über mehrere tabellen
3466
June 25, 2009 09:38AM
2714
June 25, 2009 03:48PM
2514
June 26, 2009 01:47AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.