How to use group by clause to join two tables....

SELECT DISTINCT  A.FEATNO AS SNO, A.MEASUREMENT AS MEASUREFEATURE, A.NOMINAL_DIMENSION AS NOMINALVALUE, 

                      A.NOMINAL_PLUS AS NPLUS, A.NOMINAL_MINUS AS NMINUS, B.ACTUAL_DIMENSION AS ACTVALUE, B.DEVIATION AS DEVIATION, 

                      B.OUT_OF_TOLERENCE AS OUTOFTOLERANCE, B.REMARKS AS REMARKS, '"+Batch_No+"' AS BATCHNO, B.PARTNO AS PARTNO

FROM         dbo.FEATURES A INNER JOIN

                      dbo.DETAIL B ON A.FEATNO = B.SNO

WHERE     (B.BATCH_CODE = '" + Batch_Code + "')

GROUP BY A.FEATNO, A.MEASUREMENT, A.NOMINAL_DIMENSION, A.NOMINAL_PLUS, A.NOMINAL_MINUS, B.ACTUAL_DIMENSION, B.DEVIATION, 

                      B.OUT_OF_TOLERENCE, B.REMARKS, B.PARTNO

HAVING      (B.REMARKS = '" + ReportName + "')

ORDER BY A.FEATNO

Best Regard's
Prabhakar