"Bob Bedford" <bob@bedford.com> a écrit dans le message de
news:467a93d0$0$3789$5402220f@news.sunrise.ch...
>
> select name from customer, count(ordersid) from orders, count (questionid)
> from customer
> left join orders on customer.customerid = order.customerid
> left join questions on customer.customerid = questions.customerid
>
> Is this possible ? how ?

try to add "group by customerid"
(look at this recent thread "speedest way to handle a select
table1,count(table2) where table1.idtable1=table2.idtable1 ?")