Verschachtelte SQL Abfrage

[Schodn]

Delphi-Quellcode:

aqTmp.SQL.Add('SELECT a.stil, a.raum, a.brett, a.bild, b.brett_bez, b.id_adam FROM showroom a' +
                       ' INNER JOIN adam_brett b' +
                       ' ON a.brett = b.brett_bez' +
                       ' WHERE (a.stil = :Param) AND (a.raum = :Param2) AND (b.id_adam = :Param3)');

        aqTmp.Parameters.ParamByName('Param').Value := s_einrichtungsstil;
        aqTmp.Parameters.ParamByName('Param2').Value := s_raum;
        aqTmp.Parameters.ParamByName('Param3').Value := s_brett;

hilft dir das weiter?