This problem is o.k. i had two selects in index.php.

Thanks

Tomas

----- Original Message -----
From: "Äěčňđčé" <dskalugin@...>
To: "Tomas Holenda TH SOFT" <firebird-php@yahoogroups.com>
Sent: Friday, May 21, 2004 12:26 PM
Subject: Re: [firebird-php] Problem syntax SQL from PHP to Firebird 1.5


> 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@...
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>