select * from t where t.a = 1 as t1 left join t2 on t1.b = t2.b
有没有这样的sql语句...
就是加个where条件后.再去left join..
有没有这样的sql语句...
就是加个where条件后.再去left join..
解决方案 »
- 存储过程的应用情况
- 请教:机子上安装了SQL2000和2005 现在用动易SQL版的,要连2000的连不上 在线等。
- 请教数据库同步的问题
- 再求一SQL语句.在线给分
- 存储过程
- !!!!!急!!!!最简单的常识性问题
- 第3次问同一个问题。
- sql中怎么根据汉字的拼音首字母查询?
- 伺服器: 訊息 8908,層級 22,狀態 6,行 1.Table error: Database ID 20, object ID 1735065317, index ID 2. Chain linkage mismatch.
- uniqueidentifier类型字段在数据库中做条件查询查不到数据
- 批量修改
- 如何在英文版的 SQL SERVER 2000 中插入中文内容的参数?
U can:select * from (select * from t where t.a = 1) as t1 left join t2 on t1.b = t2.b
*
from
(select * from t where t.a = 1) as t1
left join
t2
on
t1.b = t2.b这样?
select * from t where t.a = 1) as t1 left join t2 on t1.b = t2.b
这样
select * from (
select * from t where t.a = 1) as t1
left join t2
on t1.b = t2.b
select * from t left join t2 on t.b = t2.b where t.a = 1
select * from (select * from t where t.a=1) as t1 left join t2 on t1.b=t2.b
(select * from t where t.a = 1) as t1 left join t2 on t1.b = t2.b
(select * from t where t.a = 1) as t1 left join t2 on t1.b = t2.b
就这样把前面所有的条件弄成自定义表
你的写法不存在
select * from
(select * from t where t.a = 1) as t1 left join t2 on t1.b = t2.b
select * from t where t.a = 1 as t1 left join t2 on t1.b = t2.b--等价于
select * from t t1,t t2 where t1.b = t2.b