MySQL Forums
Forum List  »  German

Re: "und gleichzeitig" in einer Tabelle
Posted by: Thomas Wiedmann
Date: October 28, 2011 09:48AM

Ungetestet in etwa so (wenn ich mich nicht vertippt habe)

SELECT b5.a
 FROM ( SELECT a
          FROM tabelle
         WHERE b = 5
      ) b5
 JOIN ( SELECT a
          FROM tabelle
         WHERE b = 6
      ) b6
   ON b6.a = b5.a
ORDER BY b5.a;

Grüße
Thomas

Options: ReplyQuote


Subject
Views
Written By
Posted
3807
October 27, 2011 02:42PM
Re: "und gleichzeitig" in einer Tabelle
811
October 28, 2011 09:48AM


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.