3个表连接查询
@方谦2394：数据库中,有三个表,如何连接查询 -
茹柏17521573236…… 科目表(科目编号,科目名称) 成绩表(科目编号,姓名编号,成绩)用一般的连接查询出来会是重复的(名字重复:张三 数学 12,张三 语文 12,张三 历史 12)出来的就是这样,
@方谦2394：数据库中如何做到三个表连接啊? -
茹柏17521573236…… 比如说有三张表a,b,c a(id,name,do) b(course,no,class) c(no,id,x) 查询所有信息 select * from a join c on a.id=c.id join b on b.no=c.no
@方谦2394：一个3表的sqlserver连接查询怎么写 -
茹柏17521573236…… select a.aid,a.aname,b.Bnum,c.Cstr from a,b,c where a.aid=b.aid and a.aid=c.aid---- 或者你要的是 select aid,aname from a union all select aid,bnum from b union all select aid,cstr from c;
@方谦2394：三个表之间的查询的sql语句 -
茹柏17521573236…… 看看我下面这个就知道了 SELECT u.u_id, u.u_name, u.u_pass, u.u_tname, u.u_email, r.r_id, r.r_name, g.g_id, g.g_name, ur.c_id FROM dbo.Nx_user AS u LEFT OUTER JOIN dbo.Nx_urcenter AS ur ON u.u_id = ur.u_id LEFT OUTER JOIN dbo.Nx_role AS r ON ur.r_id = r.r_id LEFT OUTER JOIN dbo.Nx_group AS g ON r.g_id = g.g_id
@方谦2394：三个表连接查询并汇总 -
茹柏17521573236…… select a.aa,sum(t1.数量a),sum(t1.数量b),sum(t1.数量c),sum(t2.数量d),sum(t2.数量e),sum(t2.数量f),sum(t3.数量g),sum(t3.数量h),sum(t3.数量k),(select aa from t1 union select aa from t2 union select aa from t3) ta left outer join t1 on ta.aa = t1.aa left outer join t2 on ta.aa = t2.aa left outer join t3 on ta.aa = t3aa group by ta.aa
@方谦2394：sql 3个表的连接查询 -
茹柏17521573236…… select ml.ml_id,ml.ml_name, dl.dl_name,jd.jd_name,ml.ml_date from ml left join dl on ml.dl_id=dl.dl_id left join jd on ml.jd_id=jd.jd_id
@方谦2394：3个表的SQL查询 -
茹柏17521573236…… select * from t1 where t_id not in (select user_id from t3 where lesson_id=(select t_id from t2 where 课程名='课程名')) 5个5个的显示出是不是就显示5个 select top 5 * from t1 where t_id not in (select user_id from t3 where lesson_id=(select t_id from t2 where 课程名='课程名'))
@方谦2394：mysql 三个表怎么全连接查询 -
茹柏17521573236…… 改为:SELECT count(*) as num FROM (income as i join outgo as o on i.areaid=o.areaid) join centeroutgo as c on i.areaid =c.areaid还有就是确保income表、outgo表和centeroutgo表这三个表的areaid字段类型一致.我没见过有Full outer join的,...
@方谦2394：在access里三个表连接查询语句怎么写?
茹柏17521573236…… acces不支持三个表以上的连接,只能子查询
@方谦2394：sql 3张表连接查询
茹柏17521573236…… 补充下楼上的select c.id,c.name from a,b,c where c.id=b.cid and b.aid=a.id and a.id=xxx其实既然知道 a的id了,那就不用关联a表了直接写 select c.id,c.name from b,c where c.id=b.cid and b.aid=xxx
茹柏17521573236…… 科目表(科目编号,科目名称) 成绩表(科目编号,姓名编号,成绩)用一般的连接查询出来会是重复的(名字重复:张三 数学 12,张三 语文 12,张三 历史 12)出来的就是这样,
@方谦2394：数据库中如何做到三个表连接啊? -
茹柏17521573236…… 比如说有三张表a,b,c a(id,name,do) b(course,no,class) c(no,id,x) 查询所有信息 select * from a join c on a.id=c.id join b on b.no=c.no
@方谦2394：一个3表的sqlserver连接查询怎么写 -
茹柏17521573236…… select a.aid,a.aname,b.Bnum,c.Cstr from a,b,c where a.aid=b.aid and a.aid=c.aid---- 或者你要的是 select aid,aname from a union all select aid,bnum from b union all select aid,cstr from c;
@方谦2394：三个表之间的查询的sql语句 -
茹柏17521573236…… 看看我下面这个就知道了 SELECT u.u_id, u.u_name, u.u_pass, u.u_tname, u.u_email, r.r_id, r.r_name, g.g_id, g.g_name, ur.c_id FROM dbo.Nx_user AS u LEFT OUTER JOIN dbo.Nx_urcenter AS ur ON u.u_id = ur.u_id LEFT OUTER JOIN dbo.Nx_role AS r ON ur.r_id = r.r_id LEFT OUTER JOIN dbo.Nx_group AS g ON r.g_id = g.g_id
@方谦2394：三个表连接查询并汇总 -
茹柏17521573236…… select a.aa,sum(t1.数量a),sum(t1.数量b),sum(t1.数量c),sum(t2.数量d),sum(t2.数量e),sum(t2.数量f),sum(t3.数量g),sum(t3.数量h),sum(t3.数量k),(select aa from t1 union select aa from t2 union select aa from t3) ta left outer join t1 on ta.aa = t1.aa left outer join t2 on ta.aa = t2.aa left outer join t3 on ta.aa = t3aa group by ta.aa
@方谦2394：sql 3个表的连接查询 -
茹柏17521573236…… select ml.ml_id,ml.ml_name, dl.dl_name,jd.jd_name,ml.ml_date from ml left join dl on ml.dl_id=dl.dl_id left join jd on ml.jd_id=jd.jd_id
@方谦2394：3个表的SQL查询 -
茹柏17521573236…… select * from t1 where t_id not in (select user_id from t3 where lesson_id=(select t_id from t2 where 课程名='课程名')) 5个5个的显示出是不是就显示5个 select top 5 * from t1 where t_id not in (select user_id from t3 where lesson_id=(select t_id from t2 where 课程名='课程名'))
@方谦2394：mysql 三个表怎么全连接查询 -
茹柏17521573236…… 改为:SELECT count(*) as num FROM (income as i join outgo as o on i.areaid=o.areaid) join centeroutgo as c on i.areaid =c.areaid还有就是确保income表、outgo表和centeroutgo表这三个表的areaid字段类型一致.我没见过有Full outer join的,...
@方谦2394：在access里三个表连接查询语句怎么写?
茹柏17521573236…… acces不支持三个表以上的连接,只能子查询
@方谦2394：sql 3张表连接查询
茹柏17521573236…… 补充下楼上的select c.id,c.name from a,b,c where c.id=b.cid and b.aid=a.id and a.id=xxx其实既然知道 a的id了,那就不用关联a表了直接写 select c.id,c.name from b,c where c.id=b.cid and b.aid=xxx
