Subject Re: [firebird-php] Problem syntax SQL from PHP to Firebird 1.5
Author Äěčňđčé
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
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@...