Posted by Pierre on 11/17/06 22:35

KrunoG <REMOVErad.astronomija@gmail.com> wrote:

> select c.id, c.nom, c.prenom, t.tcs
> from clients c left join inscriptions i on i.client =c.id
> left join (select count(*) Tickets as 'tcs', client
> as 'cly'
> from tickets
> group by client /*or cly*/) AS t ON
> c.id=t.cly
> order by c.nom, c.prenom*/

Hi, that one works well thanks for your help.

--
Pierre

[Back to original message]