调拨入出单号=(SELECT diaobo_inform.diaobo_code FROM dbinform_detail,diaobo_inform where diaobo_inform.diaobo_code=dbinform_detail.diaobo_code ),
调出仓库名称=(select store_name from storehouse ,diaobo_inform where diaobo_inform.outstore_code=storehouse.store_code),
调入仓库名称=(select store_name from storehouse ,diaobo_inform where diaobo_inform.instore_code=storehouse.store_code),
调拨日期=(SELECT diaobo_inform.diaobo_datetime FROM diaobo_inform ),
调拨数量=(select dbinform_detail.dbd_outamount from dbinform_detail),这里面 的子查询返回的值多于一个,意思是 : 你将多个值 附值 给一个变量 ,不行,
要不你就用 in
调出仓库名称=(select store_name from storehouse ,diaobo_inform where diaobo_inform.outstore_code=storehouse.store_code),
调入仓库名称=(select store_name from storehouse ,diaobo_inform where diaobo_inform.instore_code=storehouse.store_code),
调拨日期=(SELECT diaobo_inform.diaobo_datetime FROM diaobo_inform ),
调拨数量=(select dbinform_detail.dbd_outamount from dbinform_detail),这里面 的子查询返回的值多于一个,意思是 : 你将多个值 附值 给一个变量 ,不行,
要不你就用 in
单号 调拨出库编码 调拨出库编码 日期 数量
DBTZ051025183042125 0908 0903 2005-10-25 18:30:42.000 16.00
DBTZ051027100731656 1000 2001 2005-10-27 10:07:31.000 190.00
DBTZ051027100928656 1000 0802 2005-10-27 10:09:28.000 140.00
DBTZ051027100954843 1000 0801 2005-10-27 10:09:54.000 100.00
DBTZ051027101020984 1000 0705 2005-10-27 10:10:20.000 80.00
我想把仓库编码改成仓库名称!!
SELECT
调拨入出单号=(SELECT top 1 diaobo_inform.diaobo_code FROM dbinform_detail,diaobo_inform where diaobo_inform.diaobo_code=dbinform_detail.diaobo_code ),
调出仓库名称=(select top 1 store_name from storehouse ,diaobo_inform where diaobo_inform.outstore_code=storehouse.store_code),
调入仓库名称=(select top 1 store_name from storehouse ,diaobo_inform where diaobo_inform.instore_code=storehouse.store_code),
调拨日期=(SELECT top 1 diaobo_inform.diaobo_datetime FROM diaobo_inform ),
调拨数量=(select top 1 dbinform_detail.dbd_outamount from dbinform_detail),
NID = IDENTITY(INT,1,1)
INTO #T
FROM diaobo_inform,storehouse,dbinform_detail
select 调拨入出单号=a.diaobo_code,
调出仓库名称=(select store_name from storehouse where store_code=a.outstore_code),
调入仓库名称=(select store_name from storehouse where store_code=a.instore_code),
调拨日期=a.日期,
调拨数量=a.数量,
NID = IDENTITY(INT,1,1)
INTO #T
FROM dbinform_detail a
调拨入出单号=(SELECT top 1 diaobo_inform.diaobo_code FROM dbinform_detail,diaobo_inform where diaobo_inform.diaobo_code=dbinform_detail.diaobo_code ),
调出仓库名称=(select top 1 store_name from storehouse ,diaobo_inform where diaobo_inform.outstore_code=storehouse.store_code),
调入仓库名称=(selecttop 1 store_name from storehouse ,diaobo_inform where diaobo_inform.instore_code=storehouse.store_code),
调拨日期=(SELECT diaobo_inform.diaobo_datetime FROM diaobo_inform ),
调拨数量=(selec ttop 1 dbinform_detail.dbd_outamount from dbinform_detail where 条件),
NID = IDENTITY(INT,1,1)
INTO #T
FROM diaobo_inform,storehouse,dbinform_detail
( select store_name from storehouse where store_code=a.outstore_code)as '调出仓库名称',
( select store_name from storehouse where store_code=a.instore_code) as '调入仓库名称',
convert(char(10),a.diaobo_datetime,120)as '调拨日期',
dbinform_detail.dbd_outamount as '调拨数量',
mobile_goods.goods_name as '商品名称'
from diaobo_inform a,dbinform_detail,mobile_goods
调拨入出单号 = diaobo_inform.diaobo_code,
调出仓库名称 = (select top 1 storehouse.store_name from storehouse ,diaobo_inform where diaobo_inform.outstore_code=storehouse.store_code),
调入仓库名称 = (select top 1 storehouse.store_name from storehouse ,diaobo_inform where diaobo_inform.instore_code=storehouse.store_code),
调拨日期 = diaobo_inform.diaobo_datetime,
调拨数量 = dbinform_detail.dbd_outamount,
NID = IDENTITY(INT,1,1)
INTO #T
FROM diaobo_inform,dbinform_detail
Where diaobo_inform.diaobo_code=dbinform_detail.diaobo_code
调出仓库名称=so.store_name,
调入仓库名称=si.store_name,
调拨日期=m.diaobo_datetime,
调拨数量=l.dbd_outamount,
NID = IDENTITY(INT,1,1)
INTO #T
FROM diaobo_inform m, dbinform_detail l,
storehouse so, storehouse si
WHERE m.diaobo_code=l.diaobo_code
AND m.outstore_code=so.store_code
AND m.instore_code=si.store_code