select a.other,b.name1,c.name2,d.name3,e.name4
from a,b,c,d,e
where a.id1=b.id1 and a.id2=c.id2 and a.id3=d.id3 and a.id4=e.id4
from a,b,c,d,e
where a.id1=b.id1 and a.id2=c.id2 and a.id3=d.id3 and a.id4=e.id4
解决方案 »
- 急求一sql语句!在线等!
- 【紧急求助】链接服务器,总是提示 sql不存在
- 怎样把一个表中的某列改为标识列?
- 特殊的sql查询
- SQLTables, SQLColumns究竟做了什么?(100分)
- 怎样将图片存入SQL Server 中,请高手帮忙
- 如何把sqlserver建表代码改成mysql或者oracle的 大神帮帮忙
- 谁能告诉我在SQL7。0存储过程中用什么函数获取当前日期,是DATETIME类型的??
- 执行SQL Sever2000下的存储过程出现不能传递DATETIME型参数问题
- SQL中分类汇总的问题
- 帮忙看看这该怎么做
- 在windows2003中怎么也装不上SQL2000,会是什么原因啊。
from a join b on a.id1=b.id1
join c on a.id2=c.id2
join d on a.id3=d.id3
join e on a.id4=e.id4
from a,b,c,d,e
where a.id1=b.id1 and a.id2=c.id2 and a.id3=d.id3 and a.id4=e.id4
on a.Id1=b.id2 left join c on c.id3=a.id1 left join d on d.id4=a.id1
select a.other,b.name1,c.name2,d.name3,e.name4
from a join b on a.id1=b.id1
join c on a.id2=c.id2
join d on a.id3=d.id3
join e on a.id4=e.id4
---------如果他们是同一表中的字段,就直接写 fild1+fild2 as '别名',否则字段名前要加表名:
tbl1.fild1+tbl2.fild2 as '别名'
from a join b on a.id1=b.id1
join c on a.id2=c.id2
join d on a.id3=d.id3
join e on a.id4=e.id4
from a join b on a.id1=b.id1
Left join c on a.id2=c.id2
Left join d on a.id3=d.id3
Left join e on a.id4=e.id4