left join as mysql
Primary tabs
left join on as
псевдоним для результата left join
alias for the result of the left join
как-то так =
SELECT '1-ый курс',COUNT(*) FROM ( SELECT DISTINCT SUBJ_NAME FROM SUBJECT WHERE SEMESTER=1 OR SEMESTER=2) AS MYTABLE1 UNION SELECT '2-ой курс',COUNT(*) FROM ( SELECT DISTINCT SUBJ_NAME FROM SUBJECT WHERE SEMESTER=3 OR SEMESTER=4) AS MYTABLE2; --------------------------
- vedro-compota's blog
- Log in to post comments
- 4745 reads