ADO / DBGrid / Query / mehrere Tabellen

[omata]

SQL-Code:

SELECT *, IIf(y.id IS NULL;'Nein';'Ja') AS entliehen
FROM mastertabelle x
LEFT JOIN (SELECT DISTINCT id
           FROM tabelle6) y
  ON x.id = y.id