Answer the question
In order to leave comments, you need to log in
Completely confused, Help me, what and where is wrong?
So, there are 2 tables - schedule and subjects. I'm trying to use left join in conjunction with where, but so far it doesn't work.
schedule looks like this:
subjects like this:
Everything is displayed, but only if there is only 1 entry in the schedule. I understand that "WHERE ... ='Monday'" and "WHERE ...`student_id`='1'" do not work, but I can't figure out how to make them work. I really ask for help.
SQL code: pastebin.com/q2bqedf8
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question