Re: Query mit zweifacher Verknüpfung auf eine Spalte
Hallo Jörg,
so..? oder habe ich was nicht verstanden?
mysql> SELECT a.*, la.*
-> FROM adress a
-> JOIN lieferanschrift la
-> ON a.nr = la.kunde
-> ORDER BY a.nr;
+----+-------+---------+------+-------+----------+
| nr | name | strasse | ort | kunde | lieferAn |
+----+-------+---------+------+-------+----------+
| 1 | Anton | Agasse | Aort | 1 | 1 |
| 1 | Anton | Agasse | Aort | 1 | 2 |
| 1 | Anton | Agasse | Aort | 1 | 3 |
| 4 | Berta | Bgasse | Bort | 4 | 5 |
+----+-------+---------+------+-------+----------+
4 rows in set (0.00 sec)
mysql>
Grüße
Thomas
Subject
Views
Written By
Posted
2238
November 26, 2011 04:13PM
1018
November 27, 2011 02:57AM
Re: Query mit zweifacher Verknüpfung auf eine Spalte
1092
November 27, 2011 04:20AM
1145
November 27, 2011 03:31PM
1118
November 28, 2011 11:32AM
896
November 29, 2011 05:13AM
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.