join and pivot tables


#1

Hi everybody,
I wanted to join two tables and also pivot tables.
table student: student_id Lname Fname gr sex dob
1 Burban John 2M M 21.02.1996
2 Duboit Melissa 2J F 14.09.1997
3 Smith Bernard 2D M 17.06.1996
4 Marsden Julia 2A F 10.05.1996
table exam: exam_id exam_name point_scored student_id
1 exam1 64 2
2 exam2 45 3
3 exam3 34 1
4 exam4 52 4
5 exam1 64 4
6 exam2 45 1
7 exam4 52 3
8 exam4 52 2
9 exam3 38 4
I would like to pivot and join the two tables and finally have a html presentation like this:
Lname Fname gr sex dob exam1 exam2 exam3 exam4
Burban John 2M M 21.02.1996 0 45 34 0
Duboit Melissa 2J F 14.09.1997 64 0 0 52
Smith Bernard 2D M 17.06.1996 0 45 0 52
Marsden Julia 2A F 10.05.1996 64 0 38 64
If you can help me on that. Thank you very much for all your advice.


#2

You can use connectors to get data from server side from two tables
docs.dhtmlx.com/doku.php?id=dhtm … ral_tables

And on client side, you can use grid in pivot mode
docs.dhtmlx.com/doku.php?id=toc_pivot


#3

thanks very much