Anonymous

SELECT E Career.name, m1.name AS Subject, Plan.credits, Plan.h_teoric, Plan.h_pract, m2.name AS LinkFROM Career, Plan, Subject m1, Subject m2WHERE Plan.id_career = Career.id_careerAND Plan.id_subject = m1.id_subject ANDPlan.link = m2.id_subjectIN THE TABLE Plan, link field CAN BE NULL, I NEED TO SHOW THOSE FIELDS TOO IN THIS QUERY