Ich kenne zwar
IB nicht, aber teste doch mal folgende Formulierung ...
SQL-Code:
SELECT Bla1, BLA2 from TABLE1 T1
INNER JOIN
(SELECT NR FROM TABLE2 WHERE NR = :NR) T2
ON T2.Nr = T1.N1
Übrigens ...
fehlt da nicht was ?
SELECT Bla1, BLA2 from TABLE1 T1 WHERE (SELECT NR FROM TABLE2 WHERE NR = :NR);
SQL-Code:
SELECT Bla1, BLA2 from TABLE1 T1 WHERE T1.Nr IN (SELECT NR FROM TABLE2 WHERE NR = :NR);
SELECT Bla1, BLA2 from TABLE1 T1 WHERE T1.Nr = (SELECT NR FROM TABLE2 WHERE NR = :NR);
Schöne Grüße,
Jens