表A
id aa_id bb_id cc_id
1 1 3 5
2 1 1 4
3 2 4 1
表B
id name url type
1 163 http://www.163.com 1
2 sohu http://www.sohu.com 1
3 sina http://sina.com.cn 2
4 tom http://tom.com 3
5 china http://china.com 4
表A的aa_id bb_id cc_id 存的都是表B中的id想要的结果是查询表A where id=1
出来的结果是
id aa_id name url bb_id name url cc_id name url
1 1 163 http://www.163.com 3 sina http://sina.com.cn 5 china http://china.com
id aa_id bb_id cc_id
1 1 3 5
2 1 1 4
3 2 4 1
表B
id name url type
1 163 http://www.163.com 1
2 sohu http://www.sohu.com 1
3 sina http://sina.com.cn 2
4 tom http://tom.com 3
5 china http://china.com 4
表A的aa_id bb_id cc_id 存的都是表B中的id想要的结果是查询表A where id=1
出来的结果是
id aa_id name url bb_id name url cc_id name url
1 1 163 http://www.163.com 3 sina http://sina.com.cn 5 china http://china.com
解决方案 »
- ms sql 自定义函数问题,执行无结果
- 请帮助改正我的这行tsql语句, 不会join了
- ODBC中命名管道不通,但TCP/IP可以连通
- 一个sql查询
- 问一个很简单的SQL查询,在线等
- SQL Sever的企业管理器突然出现SQLDMO未注册,重装了好几次还是一样,用RegSvr32 sqldmo.dll出现SQLDMO.dll中的DLLRegisterSever失败,返
- 我还不知道mysql和sql server有什么不同,请大侠教教菜鸟吧!
- 数据库的定时更新问题?
- 存储过程中不可以创建视图?急
- 高手,中手,新手里面看
- SQL查询语句
- SELECT TOP @Number ID FROM ....的存储过程为什么总是提示语法错误??
SELECT dbo.A.id, dbo.B.id AS Expr1, dbo.B.name, dbo.B.url, B_1.id AS Expr2,
B_1.name AS Expr3, B_1.url AS Expr4, B_2.id AS Expr5, B_2.name AS Expr6,
B_2.url AS Expr7
FROM dbo.A INNER JOIN
dbo.B ON dbo.A.aa_id = dbo.B.id INNER JOIN
dbo.B B_1 ON dbo.A.bb_id = B_1.id INNER JOIN
dbo.B B_2 ON dbo.A.cc_id = B_2.id
---------------------------------------------------------------------创建存储过程
--------------------------创建存储过程-------------------------------
CREATE PROCEDURE Pquary
@id char(10)
AS
select * from VIEW1 where id= @id
GO
---------------------------------------------------------------------然后调用这个存储过程就可以了
left join 表B b on a.aa_id=b.id
left join 表B c on a.bb_id=c.id
left join 表B d on a.cc_id=d.id
where a.id=1
insert into tblA select 1,1,3,5
union all select 2,1,1,4create table tblB(id int,name nvarchar(20),url nvarchar(50),type int)
insert into tblB select 1,'163','http://www.163.com',1
union all select 2,'sohu','http://www.sohu.com',1
union all select 3,'sina','http://www.sina.com',2
union all select 5,'china','http://www.china.com',4
select (select id from tblB where id=tblA.aa_id),
(select name from tblB where id=tblA.aa_id),
(select url from tblB where id=tblA.aa_id),
(select id from tblB where id=tblA.bb_id),
(select name from tblB where id=tblA.bb_id),
(select url from tblB where id=tblA.bb_id),
(select id from tblB where id=tblA.cc_id),
(select name from tblB where id=tblA.cc_id),
(select url from tblB where id=tblA.cc_id)
from tblA where id=1drop table tblA
drop table tblB
select a.id,b.*,c.*,d.* from 表A a
left join 表B b on a.aa_id=b.id
left join 表B c on a.bb_id=c.id
left join 表B d on a.cc_id=d.id
where a.id=1还是这个好,高