sql连接三个表查询例子
@仲孙826:关于SQL中多表连接的问题:3个表以上,请举例说明. -
颛命17767246887…… 不用非得相同的字段,但是字段和字段之间需要有一致性才可以的 select a.id,b.name,c.sex from a inner join b on a.id=b.id inner join c on a.id=c.id 以上,希望对你有所帮助
@仲孙826:求三表联合查询的SQL查询语句 -
颛命17767246887…… 车讯语句:select username,psw from (a1 left join a2 on a1.a1_id=a2.a1_id) left join a3 on a1.a1_id=a3.a1_id 这样写: SELECT S.SName AS 姓名, CS.CourseName AS 课程, C.Score AS 成绩 FROM Students AS S INNER JOIN Score AS C ...
@仲孙826:sql语句查询数据是和三张表有关联的应该怎么写? -
颛命17767246887…… select School.SchoolID,Student.StudentName from School full join Class on School.ClassId=Class.ClassId full join Student on Class.StudentId=Student.StudentId 要查找的东西放在最上面,然后连接表,连接条件.就这样.
@仲孙826:怎么用一句sql查询三个表并输出三个表的内容 -
颛命17767246887…… select table1.id,table1.title,table1.content ,table1.s_time from table1 union select table2.id , table2.title_a , table2.content ,table2.time from table2 union select table3.id , table3.title , table3.content ,table3.time from table3 order by s_time 肯定正确啦^_^
@仲孙826:请教一个 SQL 语句,三表联查 -
颛命17767246887…… 上面说法都不对,我觉得楼主是想要这样的结果:abc三个学生,123三个社团,应该得出的结果应该是9条记录,是abc三个学生分别针对123三个社团有没有参加,就算没有参加也要列出来.如果用上面的写法,没有参加任何一个社团的学生只...
@仲孙826:sql 语句操作三个表 -
颛命17767246887…… 很简单的,三个表关联下再sum、group下就可以了.表及其表中字段命名如下:销售单表(XSJL) 商品编码(SPCODE) 金额(XSJE) 时间(XSSJ) 仓位号(CWH) 商品表(SP) 商品编码(SPCODE) 厂商编码(CSCODE) 厂商表(CSB) 厂商编码(CSCODE) 厂商名称(CSNAME) 查询语句:select C.CSCODE,C.CSNAME,SUM(A.XSJE) from XSJL A ,SP B ,CSB C WHERE A.SPCODE=B.SPCODE AND B.CSCODE=C.CSCODE GROUP BY C.CSCODE,C.CSNAME
@仲孙826:3个表的SQL查询 -
颛命17767246887…… 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 课程名='课程名'))
@仲孙826:sql server三张表之间的查询 -
颛命17767246887…… select * from B right join A on B.userid=A.userid right join C on B.eqid=C.eqid 这个是以B表中的数据主主导,显示结果为所有的B表数据,对应的其他表的数据,如果有就显示,没有就显示为NLL
@仲孙826:sql 3张表连接查询
颛命17767246887…… 补充下楼上的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
@仲孙826:三个表之间的查询的sql语句 -
颛命17767246887…… 看看我下面这个就知道了 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
颛命17767246887…… 不用非得相同的字段,但是字段和字段之间需要有一致性才可以的 select a.id,b.name,c.sex from a inner join b on a.id=b.id inner join c on a.id=c.id 以上,希望对你有所帮助
@仲孙826:求三表联合查询的SQL查询语句 -
颛命17767246887…… 车讯语句:select username,psw from (a1 left join a2 on a1.a1_id=a2.a1_id) left join a3 on a1.a1_id=a3.a1_id 这样写: SELECT S.SName AS 姓名, CS.CourseName AS 课程, C.Score AS 成绩 FROM Students AS S INNER JOIN Score AS C ...
@仲孙826:sql语句查询数据是和三张表有关联的应该怎么写? -
颛命17767246887…… select School.SchoolID,Student.StudentName from School full join Class on School.ClassId=Class.ClassId full join Student on Class.StudentId=Student.StudentId 要查找的东西放在最上面,然后连接表,连接条件.就这样.
@仲孙826:怎么用一句sql查询三个表并输出三个表的内容 -
颛命17767246887…… select table1.id,table1.title,table1.content ,table1.s_time from table1 union select table2.id , table2.title_a , table2.content ,table2.time from table2 union select table3.id , table3.title , table3.content ,table3.time from table3 order by s_time 肯定正确啦^_^
@仲孙826:请教一个 SQL 语句,三表联查 -
颛命17767246887…… 上面说法都不对,我觉得楼主是想要这样的结果:abc三个学生,123三个社团,应该得出的结果应该是9条记录,是abc三个学生分别针对123三个社团有没有参加,就算没有参加也要列出来.如果用上面的写法,没有参加任何一个社团的学生只...
@仲孙826:sql 语句操作三个表 -
颛命17767246887…… 很简单的,三个表关联下再sum、group下就可以了.表及其表中字段命名如下:销售单表(XSJL) 商品编码(SPCODE) 金额(XSJE) 时间(XSSJ) 仓位号(CWH) 商品表(SP) 商品编码(SPCODE) 厂商编码(CSCODE) 厂商表(CSB) 厂商编码(CSCODE) 厂商名称(CSNAME) 查询语句:select C.CSCODE,C.CSNAME,SUM(A.XSJE) from XSJL A ,SP B ,CSB C WHERE A.SPCODE=B.SPCODE AND B.CSCODE=C.CSCODE GROUP BY C.CSCODE,C.CSNAME
@仲孙826:3个表的SQL查询 -
颛命17767246887…… 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 课程名='课程名'))
@仲孙826:sql server三张表之间的查询 -
颛命17767246887…… select * from B right join A on B.userid=A.userid right join C on B.eqid=C.eqid 这个是以B表中的数据主主导,显示结果为所有的B表数据,对应的其他表的数据,如果有就显示,没有就显示为NLL
@仲孙826:sql 3张表连接查询
颛命17767246887…… 补充下楼上的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
@仲孙826:三个表之间的查询的sql语句 -
颛命17767246887…… 看看我下面这个就知道了 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