Re: Problem with view

> I have got another problem.  I have a table(table tempOne) that has two
> fields, seqid(int) and phredscore(int).  They are one to many relationship,
> e.g. one seqid has many phredscore.  I would like to get the row that has
> the max(phredscore).  So I first created a view as follow:
> "create view maxphred as select seqid, max(phredscore) as phredscore from
> tempOne group by seqid;"
   Views  are  known to have severe problems with aggregates and   grouping.  And once again  these  are  problems  we
want to   tackle with the parse-/querytree overhaul.
 
   Oh man - this is one of the most important things I see.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #