Hello Tomas,

Friday, May 21, 2004, 1:15:27 PM, you wrote:

you assumed a misprint in filtr(Y)


LEFT JOIN filtry ON lide.filtr(Y)=filtry.id_filtry
lide(login,ap,filtr(y))
---------------------------------------------------------
THTS> I have two tables
THTS> lide(login,ap,filtry)
THTS> filtry(id_filtry,any,ap)

THTS> When I execute SQL from IBexpert or isql o linux - this is not problem.

THTS> SELECT lide.login, filtry.AP FROM lide
THTS> LEFT JOIN filtry ON lide.filtr=filtry.id_filtry
THTS> WHERE filtry.ap like '%sud%'


--
Best regards,
Dmitry mailto:dskalugin@...