MySQL Forums
Forum List  »  German

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

Options: ReplyQuote


Subject
Views
Written By
Posted
7412
June 22, 2009 10:16AM
Re: select über mehrere tabellen
3466
June 25, 2009 09:38AM
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.