MySQL Forums
Forum List  »  German

Re: select über mehrere tabellen
Posted by: Markus Schatz
Date: June 22, 2009 10:38AM

Hey!

Das Zauberwort heißt "UNION" :-)

Damit kannst du die Ergebniszeilen mehrerer Abfragen zusammenfassen.

SELECT a, b, c FROM table01
UNION [All]
SELECT a, b, c FROM table02
UNION [ALL]
SELECT a, b, c FROM table03
...

Siehe auch: http://dev.mysql.com/doc/refman/5.1/de/union.html

Mit besten Grüßen,

Markus Schatz
http://www.mschatz.com

Options: ReplyQuote


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