Hello all,

i found a solution:

if i not use table alias "B." then all works fine

B.DELETED=BOOLEAN='J,N'   >>>   DELETED=BOOLEAN='J,N'

TIB_Query.SQL

SELECT B.ADRESSID, B.NAME, B.DELETED, G.GROUP

FROM ADRESS B

JOIN ADRGROUP G ON (G.GROUPID = B.GROUPID)

WHERE B.DELETED = :DELETED

Regards,

  Kostas