i have a code in sql ....i need to implement in derby it has two tables with group by ...but it is not working i derb help me solve this
SELECT MarkInfo.RegNumber as REGISTER_NUMBER, Name as NAME ,sum(Internal +Extern) AS TOTAL,avg(Internal + Extern)AS AVERAGE from MarkInfo,StudentInfo where StudentInfo.RegNumber = MarkInfo.RegNumber group by MarkInfo.RegNumber help me to execute in derby -- View this message in context: http://www.nabble.com/how-to-use-group-by-class-with-two-tables-tp21641755p21641755.html Sent from the Apache Derby Developers mailing list archive at Nabble.com.
