select ID,b.name asDAIMA01_NAME,c.name as DAIMA02_NAME
from a,b,b c
where a.DAIMA01 =b.DAIMA
and a.DAIMA01 =c.DAIMA
from a,b,b c
where a.DAIMA01 =b.DAIMA
and a.DAIMA01 =c.DAIMA
解决方案 »
- sql 2000备份咨询
- 关于Log Explorer for SQL Server的一个问题
- 帮忙看看这是什么原因?
- 这样的查询语句怎么写?
- 怎么知道每天数据库都发生些什么变化?
- ~~~~~~~~~SQL语句关于Where中IN后用Case,马上给分!~~~~~~~
- 如何设置sql server的最大连接数?
- 请问如何在存储过程里调用脚本文件啊?50分奉送
- 竹兄,海兄,蓝色力量,流星尔,各位老大,帮忙看下,mysql问题
- delphi连接sql server
- 再问一个关于报表得简单问题
- 请问那位大哥知道在数据库里存放一般的文章、规章制度(pdf)、表格内容、图片和附加的说明、动画、flash格式上有什么区别?
select ID,(select b.name from A,B where a.DAIMA01=b.DAIMA) as DAIMA01_NAME,
(select b.name from A,B where a.DAIMA02=b.DAIMA) as DAIMA02_NAME
from A
select ID,b.name as DAIMA01_NAME,c.name as DAIMA02_NAME
from a,b,b c
where a.DAIMA01 =b.DAIMA
and a.DAIMA02 =c.DAIMA
有什么更好的方法吗
CSDNM(CSDN管理员(假的) 方法查出来为空 :)
select ID,b.name as DAIMA01_NAME,c.name as DAIMA02_NAME
from a,b,b c
where a.DAIMA01 =b.DAIMa
and a.DAIMA02 =c.DAIMA
select ID,b.name as DAIMA01_NAME,c.name as DAIMA02_NAME
from a,b,b c
where a.DAIMA01 =b.DAIMa
and a.DAIMA02 *=c.DAIMA
from (a
left join b on a.DAIMA01 =b.DAIMa )
left join b c on a.DAIMA02 *=c.DAIMA