ADO / DBGrid / Query / mehrere Tabellen

[omata]

SQL-Code:

SELECT *, iif(Leihe.Platte IS NULL,'Nein','Ja') AS Ausleihe
FROM ((((Platte AS t1
         INNER JOIN Interpret AS t2 ON t1.interpret = t2.id)
        INNER JOIN Label AS t3 ON t1.label = t3.id)
       INNER JOIN Stil AS t4 ON t1.stil = t4.id)
      INNER JOIN Qualität AS t5 ON t1.qualität = t5.id)
LEFT JOIN (SELECT DISTINCT Platte
           FROM Leihe) Leihe
  ON t1.id = Leihe.platte
WHERE platte LIKE '%blabla%'
   OR iif(Leihe.Platte IS NULL,'Nein','Ja') = 'Ja'
   OR CODE = :suchid

[tschinkes]

Omata du bist mein Held!!!!!!!!!!! *freu

[DeddyH]

[OT] Bei der Klammerung muss ich eher an LISP denken als an SQL :mrgreen: [/OT]