三表查询sql语句怎么查
@巢章4784：用SQL语句怎么查询三个表的结果 -
盖菊19431092873…… select table_a.D,table_a.E,table_b.F (select A.D as D,sum(B.E) as E from A,B where A.D=B.D group by A.D) table_a, (select A.D as D,sum(C.F) as F from A,B where A.D=C.D group by A.D) table_b where table_a.D=table_b.D
@巢章4784：如何用一条SQL语句查询3个表中的内容? -
盖菊19431092873…… 前提是表的结构应该是一样的或者处理成一样的~~~~ 表A, aid, aname, atext 表B, bid, bname, btext 表C, cid, cname, ctext SELECT * FROM ( SELECT aid AS id, aname AS name, atext AS [text] FROM A UNION SELECT bid AS id, bname AS ...
@巢章4784：求三表联合查询的SQL查询语句
盖菊19431092873…… select a.id,a.name,b.name,c.name,a.table2_id,a.table3_id,c.table2_id from table1 a,table2 b,table3 c where a.table2_id=b.id and a.table3_id=c.id and b.id=c.table2_id order by a.id; 以上语句在Oracle11g r2上测试通过,同样可以用于其他数据库,如有疑问请留言
@巢章4784：求三表联合查询的SQL查询语句 -
盖菊19431092873…… 车讯语句: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 ...
@巢章4784：三表查询,求SQl语句 -
盖菊19431092873…… select a.id,a.data,t.data2,t.data3 from a left join(select cc.a_id,bb.data data2,cc.data data3 from (select a_id,data,rank() over (partition by a_id order by data) rn from C) cc full join (select a_id,data,rank() over (partition by a_id order by data) rn from B...
@巢章4784：数据库,三表子查询,用一条SQL语句,怎么写? -
盖菊19431092873…… 这里需要使用动态sql执行,参见下面代码,测试通过.declare @v_tabname varchar(20) SELECT @v_tabname=tx_name FROM Table1 WHERE id = '已知ID' exec('update table0 set count=count-1 where id in(select t0_id from '+@v_tabname+')') go
@巢章4784：三个表之间的查询的sql语句 -
盖菊19431092873…… 看看我下面这个就知道了 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
@巢章4784：我想用sql语句实现以下查询:A,B,C为三个表,每个表里对应一个字段a,b,c;查询A,B,C三表中满足条件a的1、2 -
盖菊19431092873…… ORACLE: SELECT * FROM A,B,C WHERE INSTR(substr(a,1,3),b) > 0 or INSTR(substr(a,4,3),c) > 0 SQLSERVER: SELECT * FROM A,B,C WHERE charindex(substring(a,1,3),b) > 0 or charindex(substring(a,4,3),c) > 0
@巢章4784：SQL 三表联查 -
盖菊19431092873…… select t.*,t1.hsdwmc , from a t join b t1 on t1.hsdwmc =t.thsdwmc join c t2 on t.fzmc = t2.fzmc 我上面这样写的需要所有表都有关联才行,如果不是所有表有关联换下面这种写法 select t.*,t1.hsdwmc , t2.fzmc from a t left join b t1 on t1.hsdwmc =t.thsdwmc left join c t2 on t.fzmc = t2.fzmc
@巢章4784：请教一个 SQL 语句,三表联查 -
盖菊19431092873…… 上面说法都不对,我觉得楼主是想要这样的结果:abc三个学生,123三个社团,应该得出的结果应该是9条记录,是abc三个学生分别针对123三个社团有没有参加,就算没有参加也要列出来.如果用上面的写法,没有参加任何一个社团的学生只...
盖菊19431092873…… select table_a.D,table_a.E,table_b.F (select A.D as D,sum(B.E) as E from A,B where A.D=B.D group by A.D) table_a, (select A.D as D,sum(C.F) as F from A,B where A.D=C.D group by A.D) table_b where table_a.D=table_b.D
@巢章4784：如何用一条SQL语句查询3个表中的内容? -
盖菊19431092873…… 前提是表的结构应该是一样的或者处理成一样的~~~~ 表A, aid, aname, atext 表B, bid, bname, btext 表C, cid, cname, ctext SELECT * FROM ( SELECT aid AS id, aname AS name, atext AS [text] FROM A UNION SELECT bid AS id, bname AS ...
@巢章4784：求三表联合查询的SQL查询语句
盖菊19431092873…… select a.id,a.name,b.name,c.name,a.table2_id,a.table3_id,c.table2_id from table1 a,table2 b,table3 c where a.table2_id=b.id and a.table3_id=c.id and b.id=c.table2_id order by a.id; 以上语句在Oracle11g r2上测试通过,同样可以用于其他数据库,如有疑问请留言
@巢章4784：求三表联合查询的SQL查询语句 -
盖菊19431092873…… 车讯语句: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 ...
@巢章4784：三表查询,求SQl语句 -
盖菊19431092873…… select a.id,a.data,t.data2,t.data3 from a left join(select cc.a_id,bb.data data2,cc.data data3 from (select a_id,data,rank() over (partition by a_id order by data) rn from C) cc full join (select a_id,data,rank() over (partition by a_id order by data) rn from B...
@巢章4784：数据库,三表子查询,用一条SQL语句,怎么写? -
盖菊19431092873…… 这里需要使用动态sql执行,参见下面代码,测试通过.declare @v_tabname varchar(20) SELECT @v_tabname=tx_name FROM Table1 WHERE id = '已知ID' exec('update table0 set count=count-1 where id in(select t0_id from '+@v_tabname+')') go
@巢章4784：三个表之间的查询的sql语句 -
盖菊19431092873…… 看看我下面这个就知道了 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
@巢章4784：我想用sql语句实现以下查询:A,B,C为三个表,每个表里对应一个字段a,b,c;查询A,B,C三表中满足条件a的1、2 -
盖菊19431092873…… ORACLE: SELECT * FROM A,B,C WHERE INSTR(substr(a,1,3),b) > 0 or INSTR(substr(a,4,3),c) > 0 SQLSERVER: SELECT * FROM A,B,C WHERE charindex(substring(a,1,3),b) > 0 or charindex(substring(a,4,3),c) > 0
@巢章4784：SQL 三表联查 -
盖菊19431092873…… select t.*,t1.hsdwmc , from a t join b t1 on t1.hsdwmc =t.thsdwmc join c t2 on t.fzmc = t2.fzmc 我上面这样写的需要所有表都有关联才行,如果不是所有表有关联换下面这种写法 select t.*,t1.hsdwmc , t2.fzmc from a t left join b t1 on t1.hsdwmc =t.thsdwmc left join c t2 on t.fzmc = t2.fzmc
@巢章4784：请教一个 SQL 语句,三表联查 -
盖菊19431092873…… 上面说法都不对,我觉得楼主是想要这样的结果:abc三个学生,123三个社团,应该得出的结果应该是9条记录,是abc三个学生分别针对123三个社团有没有参加,就算没有参加也要列出来.如果用上面的写法,没有参加任何一个社团的学生只...
