0

How to Manage Many_to_Many Relationship in SQL

I want to store a student result on database, the table has the following attributes:- result_id, stu_num, subject, session, term, test_score and exam_score So that i can print the result in form of html table With the following syntx Name | Number | subject1 test score & exam score | subject2 test score & exam score |

14th Jun 2021, 2:45 PM
Umar Bello
Umar Bello - avatar
3 Respuestas
+ 2
Thank you, i used your suggestion and it solve the issue
14th Jun 2021, 7:04 PM
Umar Bello
Umar Bello - avatar
+ 1
Please tag SQL and avoid writing code/query in the thread tags https://code.sololearn.com/W3uiji9X28C1/?ref=app
14th Jun 2021, 3:32 PM
Ipang
+ 1
How many tables do you have? Only one? If so, your database has not a good structure. I think you should have at least 2 tables. If I understand the question correctly.
14th Jun 2021, 5:55 PM
dozule
dozule - avatar