left join as mysql

Primary tabs

vedro-compota's picture
Submitted by vedro-compota on Mon, 12/19/2011 - 00:36

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;


--------------------------