MySQL Forums
Forum List  »  German

Re: SELECT mit NULL über mehrere Tabellen
Posted by: Hauke Betz
Date: April 26, 2007 12:48AM

Hallo,

versuch es mit einem LEFT JOIN ...

SELECT t1.datum, t2.aText, t3.bText
FROM t1
LEFT JOIN t2 on t1.FKidA = t2.idA
LEFT JOIN t3 on t1.FKidB = t3.idB

Gruß

Hauke

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: SELECT mit NULL über mehrere Tabellen
3040
April 26, 2007 12: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.