什么意思,请楼主说明白,最好举例出原来a b c d表的数据
解决方案 »
- exec sp_executesql @gq_flag=@Sql "@gq_flag"怎么负值?? 急....在线等
- SQL查询问题?
- 求一计算行数的语句(条件如下)
- 如何把mysql中的数据导入sql server2005
- 为什么我的SQL2005从远程不需要密码就能访问
- 求一SQL报错
- 將整型轉為字串的問題,如將12轉為'0012' ,convert(varchar(4),12)不起作用?得到'12'
- 急救!。。。数据库处于置疑状态怎么处理!
- 用一Sql语句能直接实现批量删除吗?
- 三次询问数据库开发网址
- update语句 逐行修改的问题
- 1w条记录,取1千条,要求随机,用sql语句如何实现?
e.fshortnumber as fitemname,e.fmodel,c.fqty,b.FCommitQty,
(b.fqty-b.FCommitQty) as fremainqty,a.fheadselfs0141+' '+a.fheadselfs0142
as fre
from seorder a
left outer join icmo b on a.finterid=b.forderinterid
Inner Join seorderentry c on a.finterid=c.finterid
Inner Join t_organization d on d.fitemid=a.fcustid
Inner Join t_icitem e on e.fitemid=c.fitemid
where a.fmrpclosed<>1 and a.fstatus<>3 and left(e.fnumber,3)<>'1.9'
--试上面的,不行的话试下面这个:
select distinct * from (select a.fbillno,d.fshortnumber as fdepartment,a.fdate,c.fdate as fdate2,
e.fshortnumber as fitemname,e.fmodel,c.fqty,b.FCommitQty,
(b.fqty-b.FCommitQty) as fremainqty,a.fheadselfs0141+' '+a.fheadselfs0142
as fre
from seorder a
left outer join icmo b on a.finterid=b.forderinterid
Inner Join seorderentry c on a.finterid=c.finterid
Inner Join t_organization d on d.fitemid=a.fcustid
Inner Join t_icitem e on e.fitemid=c.fitemid
where a.fmrpclosed<>1 and a.fstatus<>3 and left(e.fnumber,3)<>'1.9') t