Re: [SQL] need nelp with aggregate functions

2009-11-19 Thread Another Trad
Thank you all very much. This "official" forum is really great. 2009/11/19 Oliveiros C, > Howdy, > > It is quite simple, the joins you used would output a long list of > pairs (client,computer), and, as many people has more than one computer, > many clients will appear repeated, but the COUNT k

Re: [SQL] need nelp with aggregate functions

2009-11-19 Thread Oliveiros C,
Howdy, It is quite simple, the joins you used would output a long list of pairs (client,computer), and, as many people has more than one computer, many clients will appear repeated, but the COUNT keyword will count them more than once though. The DISTINCT keyword prevents one client from appear