How To Group The Retuned Query!

Hello,

I am wondering how can I group the returned results from the sql query. For example, the following sql qurey retrieved data from a few tables from the database on conditions using "inner join". The returned results are not grouped or organized into groups. I would like to group the retrieved data based on three different tables such as "Overall", "Spectography" and "Other" using the CASE statement.


psql += "select s.szID as SampleID, rtp.nSequence as Sequence, rt.szName as TestType, ";

psql += "rtp.szName as TestName, p.szID as PointTest, p.szDescription as PointDescription, ";

psql += "r.nAlarmStatus as AlarmStatus, s.dtCollected as DateCollected, ";

psql += "rd.nDataType as DataType, rd.byData as EncodedData ";

psql += "from point p ";

psql += "inner join readtype rt on (rt.gPK = p.gReadType) ";

psql += "inner join reading r on (p.gPK = r.gPoint) ";

psql += "inner join sample s on (s.gPK = r.gSample) ";

psql += "inner join readdata rd on (rd.gReading = r.gPK) ";

psql += "inner join rtparam rtp on (rd.gRTParam = rtp.gPK) ";

psql += "where s.szID in (" + sampleList + ") ";

psql += "and rtp.szName not like '%_Sev' ";

Any suggestions would be very much appreciated.

Thanks