Kindly log in to use this feature. We’ll take you to the login page automatically.
LoginCourse Queries Syllabus Queries 3 years ago
User submissions are the sole responsibility of contributors, with TuteeHUB disclaiming liability for accuracy, copyrights, or consequences of use; content is for informational purposes only and not professional advice.
Use select distinct otherwise you obtain repeated rows do the join form REFERENCE, SYLLABUS, SUBJECT
And you shuold join the 3 tables anyway .. without knowing the join you can
INSERT INTO REFERENCE_SUBJECT (REFERENCE_ID,SYLLABUS_ID,SUBJECT_ID)
SELECT DISTINCT REFERENCE_ID SYLLABUS_ID SUBJECT_ID
FROM REFERENCE, SYLLABUS, SUBJECT;No matter what stage you're at in your education or career, TuteeHUB will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.
Kindly log in to use this feature. We’ll take you to the login page automatically.
Login
manpreet![Tuteehub forum best answer]()
Best Answer
3 years ago
I want to copy primary key from table Subject, Reference, Syllabus into table Reference_Subject. This doesn't work:
The error is