Andreas,

Thanks for your answer.
I tried this query and it worked perfectly.
I check the performance of both query (by Marathon) and it seems that query
with inner/outer joins is faster (for big number of record it can be
significant).

With FieldXXX there is also no problem with my query if there is an alias
for each NUMER fields.

What is strange for me is the way of IB_SearchPanel works.

For your query, if I search for n3=6 for example the genereted query is:

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
WHERE (select NUMER from KARNETY k where k.ID = s.ID_KARNETU) = 6
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

and it is OK

but (as i said earlier) for my query

SELECT STANOWISKA.NUMER, KARNETY.NUMER, KLIENCI.NUMER
FROM SESJE
INNER JOIN STANOWISKA
ON(STANOWISKA.ID = SESJE.ID_STANOWISKA)
LEFT OUTER JOIN KLIENCI
ON(KLIENCI.ID = SESJE.ID_KLIENTA)
LEFT OUTER JOIN KARNETY
ON(KARNETY.ID = SESJE.ID_KARNETU)

and KARNETY.NUMER=6 typed in IB_SearchPanel

the generated query is

SELECT STANOWISKA.NUMER, KARNETY.NUMER, KLIENCI.NUMER
FROM SESJE
INNER JOIN STANOWISKA
ON(STANOWISKA.ID = SESJE.ID_STANOWISKA)
LEFT OUTER JOIN KLIENCI
ON(KLIENCI.ID = SESJE.ID_KLIENTA)
LEFT OUTER JOIN KARNETY
ON(KARNETY.ID = SESJE.ID_KARNETU)
WHERE STANOWISKA.NUMER = 6

what else, for query with filed aliases

SELECT STANOWISKA.NUMER NR1, KARNETY.NUMER NR2, KLIENCI.NUMER NR3
FROM SESJE
INNER JOIN STANOWISKA
ON(STANOWISKA.ID = SESJE.ID_STANOWISKA)
LEFT OUTER JOIN KLIENCI
ON(KLIENCI.ID = SESJE.ID_KLIENTA)
LEFT OUTER JOIN KARNETY
ON(KARNETY.ID = SESJE.ID_KARNETU)

generated query is
SELECT STANOWISKA.NUMER NR1, KARNETY.NUMER NR2, KLIENCI.NUMER NR3
FROM SESJE
INNER JOIN STANOWISKA
ON(STANOWISKA.ID = SESJE.ID_STANOWISKA)
LEFT OUTER JOIN KLIENCI
ON(KLIENCI.ID = SESJE.ID_KLIENTA)
LEFT OUTER JOIN KARNETY
ON(KARNETY.ID = SESJE.ID_KARNETU)
WHERE KARNETY.NR2 = 6

Is this the right way IB_SearchPanel works?

As I remember in TTable there is an Orgin property for its fields to solve
field name problem.

Please help me.

Yagi

----- Original Message -----
From: Andreas Pohl <apohl@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, May 17, 2001 3:41 PM
Subject: Re: [IBO] TIB_SearchPanel and searching problem and another...


> 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...
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>