Answers for "how to join more then 2 column in mysql"

SQL
0

how to join more then 2 column in mysql

SELECT
  s.last_name, s.first_name,
  p.course_code, p.status, p.amount
FROM enrollment e
JOIN student s
  ON s.id=e.student_id
JOIN payment p
  ON p.course_code=e.course_code
    AND p.student_id=e.student_id;
Posted by: Guest on April-10-2021

Code answers related to "how to join more then 2 column in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language