Comments by Member 10375570

Member 10375570 13-Dec-13 3:57am View

but sir, how can i code this??

Member 10375570 13-Dec-13 3:50am View

Windows form application VB

Member 10375570 10-Dec-13 19:23pm View

The ANSWERS table have the following 4 records for example:
QPaper_ID: 50723 (all 4 records have this same value)
Marks: 4 , 5 , 2 , 9
Student_ID: CA123 (all 4 records have this same value)
Class: 8 (all 4 records have this same value)

As a result of the above query, the RESULTS table looks like this:
QPaper_ID: 50723 . 50723
Marks: 20 , 20
Grade: C , C
Student_ID: CA123 , CA123
Class: 8 , 8

AS you see, the same values are inserted twice.
Please help :(

Member 10375570 9-Dec-13 9:47am View

I just realized that it didn't. Now instead of 4 or more, the same record is inserted twice which is redundant and causing problems? How can I solve this?

Member 10375570 8-Dec-13 11:49am View

I got what my mistake was. I shouldn't have included Marks in the Group by clause :)

Comments by Member 10375570 (Top 5 by date)