110,533
社区成员
发帖
与我相关
我的任务
分享
select a.ProvinceID,a.cityID,a.DistrictID,a.schoolID,a.schoolName,a.class,a.isOpen,a.registerTime,a.classNum,a.webSite,a.cityID,b.schoolclassID,b.schoolclassName,
c.ProvinceID,c.ProvinceName,d.CityID,d.CityName,e.DistrictID,e.DistrictName
from CMS_School as a
inner join CMS_schoolClass as b
on a.class=b.schoolclassID
inner join S_Province as c on a.ProvinceID=c.ProvinceID
inner join S_City as d on a.cityID=d.CityID
inner join S_District as e on a.DistrictID=e.DistrictID
where a.isOpen=1
select a.ProvinceID,a.cityID,a.DistrictID,a.schoolID,a.schoolName,a.class,a.isOpen,a.registerTime,a.classNum,a.webSite,a.cityID,b.schoolclassID,b.schoolclassName,
c.ProvinceID,c.ProvinceName,d.CityID,d.CityName,e.DistrictID,e.DistrictName
from CMS_School as a
inner join CMS_schoolClass as b
on a.class=b.schoolclassID
where
a.isOpen=1 and a.ProvinceID=c.ProvinceID and a.cityID=d.CityID and a.DistrictID=e.DistrictID
SELECT xxx,xxx,xxx
FROM ((City INNER JOIN Depart ON City.ID = Depart.ID) INNER JOIN Duty ON Depart.ID = Duty.ID) INNER JOIN Stuff ON Duty.ID = Stuff.ID;