[V4RB] GROUP BY Recid Problems

[Frank Schima]

Hi Ruslan,


--- Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
> on 2/7/03 5:04 AM, Frank Schima at macsforever2002 at yahoo.com wrote:
> > I'm trying to do a simple 3 table join with a sum() command and a GROUP BY.
> > But if I
> > GROUP BY the Recid field of a table, then ViSQL crashes on me. Ruslan, have
> > you seen this
> > problem before? Here is a sample:
> >  SELECT a.Recid, a.Name, sum(c.amount) From a, b, c GROUP BY a.Recid
> 
> I do not remember, 
> Please send me db with few records, and SQL to do.

You can test any database and try to SELECT RecID FROM mytable GROUP BY RecID on any one
table. It crashes ViSQL. 


Best Regards,
Frank


=====
Frank Schima                <mailto:frank at labrecyclers.com>
Lab Recyclers Inc.          <http://www.labrecyclers.com/>
Gaithersburg, MD USA        <http://www.ci.gaithersburg.md.us/>

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com