|
|
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
Navigation:
[Reply to this message]
|