Hello Friends,
I got stuck in the following query, Kindly do the needful...
Following is my Table :
CREATE TABLE IF NOT EXISTS `exam_marks` (
`emid` int(11) NOT NULL AUTO_INCREMENT,
`eid` int(11) NOT NULL,
`sid` int(11) NOT NULL,
`mark` float NOT NULL,
PRIMARY KEY (`emid`)
)
And Data....
INSERT INTO `exam_marks` (`emid`, `eid`, `sid`, `mark`) VALUES
(1, 3, 28, 15),
(2, 3, 29, 2),
(3, 3, 30, 15),
(4, 3, 31, 14),
(5, 3, 32, 15),
(6, 3, 33, 6),
(7, 3, 34, 15),
(8, 3, 35, 15),
(9, 3, 36, 15),
(10, 3, 37, 10),
(11, 3, 38, 11),
(12, 3, 39, 12),
(13, 3, 40, 13),
(14, 3, 41, 14),
(15, 3, 42, 15),
(16, 3, 43, 16),
(17, 3, 44, 17),
(18, 3, 45, 18),
(19, 3, 46, 19),
(20, 3, 47, 20),
(82, 7, 29, 10),
(84, 7, 31, 10),
(86, 7, 33, 15),
(90, 7, 37, 22),
(91, 7, 38, 33),
(92, 7, 39, 22),
(93, 7, 40, 22),
(94, 7, 41, 22);
Eid 3 means its regular Exam and Eid 7 means its remedial exam... I want to prepare following report :
**************************** output i want is as follow*********
Sid reg rem
28 15 Null
29 2 10
30 15 Null
..
..
..
..
..
Thanks in advance,