SELECT PickNO, aaa= CASE orderno WHEN '' THEN
(SELECT aaa
FROM IC B
WHERE B.ICSNNo = vPickBill.ICSNNO) ELSE
(SELECT aaa
FROM Orders B
WHERE B.OrderNo = vPickBill.OrderNO) END,
bbb= CASE orderno WHEN '' THEN
(SELECT bbb
FROM IC B
WHERE B.ICSNNo = vPickBill.ICSNNO) ELSE
(SELECT bbb
FROM ORders B
WHERE B.OrderNo = vPickBill.OrderNO) END,
ccc= CASE orderno WHEN '' THEN
(SELECT ccc
FROM IC B
WHERE B.ICSNNo = vPickBill.ICSNNO) ELSE
(SELECT ccc
FROM ORders B
WHERE B.OrderNo = vPickBill.OrderNO) END
FROM vPickBill
真的只有一个字段一个字段的取吗?那如果有十几个字段(IC或Orders视图中)要取得话,不是很慢吗?有没有更好的方案?请指教阿
(SELECT aaa
FROM IC B
WHERE B.ICSNNo = vPickBill.ICSNNO) ELSE
(SELECT aaa
FROM Orders B
WHERE B.OrderNo = vPickBill.OrderNO) END,
bbb= CASE orderno WHEN '' THEN
(SELECT bbb
FROM IC B
WHERE B.ICSNNo = vPickBill.ICSNNO) ELSE
(SELECT bbb
FROM ORders B
WHERE B.OrderNo = vPickBill.OrderNO) END,
ccc= CASE orderno WHEN '' THEN
(SELECT ccc
FROM IC B
WHERE B.ICSNNo = vPickBill.ICSNNO) ELSE
(SELECT ccc
FROM ORders B
WHERE B.OrderNo = vPickBill.OrderNO) END
FROM vPickBill
真的只有一个字段一个字段的取吗?那如果有十几个字段(IC或Orders视图中)要取得话,不是很慢吗?有没有更好的方案?请指教阿
解决方案 »
- 怎样给用户升级数据库?可能增加、删除了一些字段或者建立删除了几个索引,外键等等,这些情况下怎样对客户正在使用的原有数据库做升级并且将用户现有数据库表的数据无缝导入
- 数据库还原后的文件有200G+ 机器变得很慢 这是怎么回事
- 关于改动某个特定列的排序规则
- 求SQL语句
- 大家请帮忙,将这段简单的T-SQL转换为PL-SQL
- mysql中between and 还有or 以及大于小于查询数据,那个效率最高?
- (附图说明)如果将这将两个表的数据合并在一起。
- 数据存储
- sql server 7.0中怎样生成自己想要的唯一编号
- 打开SQL Server Management Studio后无法连接
- 求SQL语句(递归查询) --------分不够可再加
- 这个sql语句如何写?急~~~
from PickBill a,Orders b
where a.OrderNo<>''
and a.OrderNo=b.OrderNo
union all
select a.*,b.aaa,b.bbb,b.ccc
from PickBill a,IC b
where a.OrderNo=''
and a.IcNo=b.IcNo