[RBASE-L] - Re: SELECT problem

[A. Razzak Memon]

At 12:05 AM 7/25/2009, Bill Niehaus wrote:

I am trying to select items and get a total for those with multiple
rows in our table based upon one column in the table (plotnum).

Bill,

Try the following and see what you get.

SELECT Trial, PlotNum, Stand1=S FROM RawData +
WHERE Trial = '098781' AND PlotNum < 1005 GROUP BY Trial, PlotNum

Very Best R:egards,

Razzak.