Re: [Firebird-devel] Parameter in subquery - a bug?

[N.D. v. B. <d.v...@ec...>]

Learning about SQL every day.....

Thanks, Diederik

"David Jencks" <dav...@di...> wrote in message
news:200...@HP......
> select
>   c.id,
>   c.name,
>   count(*) as ordercount
> from
>   customers c left join
>   (select o.custid, o.id
>     from orders o
>     where o.deliverydate < :deliverydate) do on c.id = do.custid
> where
>   c.type = :customertype
> group by
>   c.id, c.name
>
> david jencks
>
>
> _______________________________________________
> Firebird-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>