Re: Help with Group By clause

I seem to have gotten it working with (again simplified)

SELECT C.CustomerID, C.Name, C.Address, COUNT(V.VisitID) as VCount FROM CustomerTable C, VisitsTable V
WHERE C.CustomerID=V.CustomerID(+);
GROUP BY C.CustomerID, C.Name, C.Address

Is this the "correct" way to do it?

--
Randy Harris



"Randy Harris" <randy.harris_at_nospam.net> wrote in message
news:OTUaa.5905$se1.3188022_at_newssvr28.news.prodigy.com...


> I believe this can be done, but I am SQL challenged and would appreciate

> help.

>

> I need to return several fields and the count of related records in

another


> table.  It is simplified here:

>

> CustomerTable

>     CustomerID

>     Name

>     Address

>

> VisitsTable

>     CustomerID

>     VisitID

>

> This, of course, doesn't work, I think it needs a GROUP BY clause:

>

> SELECT C.CustomerID, C.Name, C.Address, COUNT(V.VisitID)

> FROM CustomerTable C, VisitsTable V

> WHERE  C.CustomerID=V.CustomerID(+);

>

> Thanks in advance for your help,

> --

> Randy Harris

>

>

>