select ไม่ได้ เคยทำใน MSSQL ใช้ EXCEPT เคยทำใน MSSQL ใช้ EXCEPT mssql แบบนี้

$result = mssql_query(" select Name_Sc,Name_Tc,Requirement.ID_Sc,Requirement.ID_Tc 
from School,Teacher,Requirement
 where  School.ID_Sc = Requirement.ID_Sc  and  Teacher.ID_Tc = Requirement.ID_Tc  and  Requirement.Re_Status  =  'connect'  
EXCEPT
(select Name_Sc,Name_Tc,Requirement.ID_Sc,Requirement.ID_Tc 
from School,Teacher,Requirement,Promise
 where  School.ID_Sc = Requirement.ID_Sc  and  Teacher.ID_Tc = Requirement.ID_Tc  and  Requirement.Re_Status  =  'connect' and Requirement.ID_Sc = Promise.ID_Sc and Requirement.ID_Tc = Promise.ID_Tc)");

$result = mysql_query(" select Name_Sc,Name_Tc,Requirement.ID_Sc,Requirement.ID_Tc 
from School,Teacher,Requirement
 where  School.ID_Sc = Requirement.ID_Sc  and  Teacher.ID_Tc = Requirement.ID_Tc  and  Requirement.Re_Status  =  'connect'  not in
(select Name_Sc,Name_Tc,Requirement.ID_Sc,Requirement.ID_Tc 
from School,Teacher,Requirement,Promise
 where  School.ID_Sc = Requirement.ID_Sc  and  Teacher.ID_Tc = Requirement.ID_Tc  and  Requirement.Re_Status  =  'connect' and Requirement.ID_Sc = Promise.ID_Sc and Requirement.ID_Tc = Promise.ID_Tc)");

$result = mysql_query(" select Name_Sc,Name_Tc,Requirement.ID_Sc,Requirement.ID_Tc 
from School,Teacher,Requirement
 where  School.ID_Sc = Requirement.ID_Sc  and  Teacher.ID_Tc = Requirement.ID_Tc  and  Requirement.Re_Status  =  'connect' and
 Requirement.ID_Sc != Promise.ID_Sc and Requirement.ID_Tc != Promise.ID_Tc");