MySQL Forums
Forum List  »  German

Advanced Search
New Topic

Re: Abfrageproblem - 2 Spalten mit einer Tabelle verknüpfen
Posted by: Steffen Groneberg
Date: November 09, 2006 01:19PM

Folgende Lösung. Gewusst wie halt.

SELECT
rep.id,
mon1.Shortname Monteur1,
mon2.Shortname Monteur2
FROM
Report rep
LEFT JOIN Monteur mon1 on rep.monteur1=mon1.id
LEFT JOIN Monteur mon2 on rep.monteur2=mon2.id

mfg Steffen

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Abfrageproblem - 2 Spalten mit einer Tabelle verknüpfen
5369
Steffen Groneberg
November 09, 2006 10:46AM
Re: Abfrageproblem - 2 Spalten mit einer Tabelle verknüpfen
2763
Steffen Groneberg
November 09, 2006 01:19PM
Re: Abfrageproblem - 2 Spalten mit einer Tabelle verknüpfen
3297
Hauke Betz
November 21, 2006 01:42AM


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.