Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //SELECT s.name, l.day_of_the_week, t.test_name, count(t.test_name) as quantity FROM `lesson` l INNER JOIN user u ON l.id_user = u.id_user AND u.login = 'ala' INNER JOIN subject s ON l.id_subject = s.id_subject INNER JOIN test t ON l.id_lesson = t.id_lesson
- name day_of_the_week test_name quantity
- Język polski pon-10:45 Testowy test 1
- dla Matematyki test_name i quantity jest puste. Jak powinienem napisać zapytani by tez matematyka sie pokazała z nullami dla test_name?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement