关联查询? 如二个表:Student字段:idname techer(外键)Techer字段:id(主键)name用Techer的id找出某一老师name和所负责学生name 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 本帖最后由 bdmh 于 2013-03-14 11:18:04 编辑 select stu.name as stuname,tea.name as teanamefrom teacher as teainner join student as stu on tea.id = stu.techerwhere tea.id = @id select A.Name as teachername,B.Name as studentname from teacher A,student B where A.id=B.id andA.id=xxxxx selectStudent.nameTeacher.namefrom Teacher,Studentwhere Teacher.id=Student.teacherandTeacher.id=*** 求教,用Repeater绑定数据 请教一个界面问题! 字符串操作 net2003求助,控件双击以后不能用.........(怀疑是微软的BUG) gridview手动绑定数据 如何实现分页 使用Gridview绑定一个DataSource,再没有编码的情况下,如何处理超时错误? 请各位看看到底是那里的问题。。。头都晕了。。 有人知道微软软件设计大赛的消息么 PictureBox的数据绑定?!(急!!!!) 关于自定义菜单 window store app 编程想给textbox加个下划线,求指导 非常非常非常奇怪的问题、C# 执行Oracle Insert 语句挂起问题。
stu.name as stuname,
tea.name as teaname
from teacher as tea
inner join student as stu
on tea.id = stu.techer
where tea.id = @id
Student.name
Teacher.name
from Teacher,Student
where
Teacher.id=Student.teacher
and
Teacher.id=***