Yagi,

try following query:

SELECT
(select NUMER from STANOWISKA st where st.ID = s.ID_STANOWISKA) as nr1,
(select NUMER from KLIENCI k where k.ID = s.ID_KLIENTA) as nr2,
(select (NUMER from KARNETY k where k.ID = s.ID_KARNETU) as nr3
FROM SESJE s

Thes inner joins are perfectly supported and there is no problem at all to
work with FieldsXXX properties.

Mit freundlichem Gruss & Best Regards

Andreas Pohl
apohl@...
www.ibp-consult.com

----- Original Message -----
From: "Yagi" <yagi@...>
To: "IBObjects" <IBObjects@yahoogroups.com>
Sent: Thursday, May 17, 2001 3:11 PM
Subject: [IBO] TIB_SearchPanel and searching problem and another...