表1：
id name
1 yang
2 &n ......
A:a1,a2,a3,a4,a5,a6
B:b1,b2,b3,b4,b5,b6,b7
注：a1，b1都是日期，现在查找2张表中相同2天日期的某些字段的数据，条件是（A.a2 = B.b7）
select a.a1, a.a2, a.a3, a.a4, a.a5, b.b1 from A a, B b where (a.a1 = '20091028' or a.a1 = '20091029') and a.a1 = b.b1 and a.a2 = b.b7;
......
表a 结构
供应商 总金额 已付 已付发票金额
aa 1000 100 0
aa 2000 0 2000
aa 3000 3000 0
bb 3000 0 0 ......
数据表abc
a_id --------ID
a_name----------名称
mz -----------某字段
现在数据表abc里有上万条数据；其中mz是空值；现在要实现的效果是：
把ID的值一一对应复制到mz里；
比如原来数据表为：
a_id a_name mz
1 aaa < ......
我的sql语句如下
select * from ｔ１ where to_char(kf_date,'yyyy-mm') = '2009-09' AND kf_caller NOT IN
(select kf_caller from ｔ１where to_char(kf_date,'yyyy-mm') = '2009-10' )
也就是本表查询 查找9月数据没在10月的
SQL code:
select * from ｔ１ whe ......
SQL code:
select *, bfl=(CAST(B.b AS DECIMAL(5,2))/B.sums) from (
SELECT tm_Types.id as typeId,tm_HTools.officename,tm_HTools.Factory,
(select ty.name from tm_Types ty where ty.id = tm_Types.id) as TypeName,
(select count(*) as max from tm_Tools where tm_tools.typeid = '101201' and tm_tools.fac ......
最新文章 : sql