我想查寻两个XueJi_XueSheng .XingMing ,但是两个XingMing的值不一样,条件是这样的:XueJi_XueSheng .XueShengID = FuXiu_BanJi .BanZhangID AND XueJi_XueSheng .XueShengID =FuXiu_BanJi .XueWeiID
这里是SQL代码:
selectFuXiu_ZhuanYe . ZhuanYeMingCheng as 专业名称 ,JiChu_JiaoXueQu . JiaoXueQuMing
as 教学区 ,JiChu_JiaoShi .XingMing as 班主任 , XueJi_XueSheng .XingMing as 班长, XueJi_XueSheng .XingMing as 学委
,FuXiu_BanJiID,FuXiuBanMing,FuXiu_BanJi .RenShu,FuXiu_BanJi .ShiFouBiYe ,FuXiu_BanJi .ShiFouPaiKe ,
FuXiu_BanJi .ShiFouDengJiChaXun,FuXiu_BanJi .BeiZhu
from FuXiu_ZhuanYe
inner join FuXiu_BanJi
on FuXiu_ZhuanYe .FuXiu_ZhuanYeID =FuXiu_BanJi .FuXiu_ZhuanYeID
inner join JiChu_JiaoXueQu
on JiChu_JiaoXueQu .JiaoXueQuIID =FuXiu_BanJi .JiaoXueQuID
inner join JiChu_JiaoShi
on JiChu_JiaoShi .JiaoShiID =FuXiu_BanJi .BanZhuRenID
inner join XueJi_XueSheng
on XueJi_XueSheng .XueShengID = FuXiu_BanJi .BanZhangID
AND XueJi_XueSheng .XueShengID =FuXiu_BanJi .XueWeiID
请大家帮忙一下,先谢过了~~~
目的是查寻两个XueJi_XueSheng .XingMing ,但是两个XingMing的值不一样,FuXiu_BanJi .BanZhangID 对应一个XueJi_XueSheng .XueShengID 查出一个XueJi_XueSheng 表的XueJi_XueSheng .XingMing ,FuXiu_BanJi .XueWeiID 对应另一个XueJi_XueSheng .XueShengID查询出另一个XueJi_XueSheng .XingMing 这里
XueJi_XueSheng 、FuXiu_BanJi 是表名,XingMing、XueShengID是XueJi_XueSheng 表的字段,XueWeiID 、BanZhangID 是FuXiu_BanJi 的字段。
代码:
selectXueJi_XueSheng .XingMing as 班长, XueJi_XueSheng .XingMing as 学委 from XueJi_XueSheng
inner join FuXiu_BanJi
on XueJi_XueSheng .XueShengID = FuXiu_BanJi .BanZhangID
AND XueJi_XueSheng .XueShengID =FuXiu_BanJi .XueWeiID
这么高分了。。有没有人帮忙一下。。。
|