Zitat von
Grolle:
Zitat von
omata:
Welche Spalten der beiden Tabellen stehen denn in Beziehung zueinander?
Keine
Hast du mal mein Edit oben ausprobiert?
Wie willst du die Zeilen zusammenführen?
In Spaltenform...
SQL-Code:
SELECT n.*, c.*
FROM notes n
LEFT JOIN correspondence c
ON c.contact_id = 22
WHERE n.recipient = 22
In Zeilenform...
SQL-Code:
SELECT n.*, c.*
FROM correspondence c
LEFT JOIN (SELECT FIRST 0 * FROM notes) n
ON 1 = 1
WHERE c.contact_id = 22
UNION
SELECT n.*, c.*
FROM notes n
LEFT JOIN (SELECT First 0 * FROM correspondence) c
ON 1 = 1
WHERE n.recipient = 22