老师,
SELEC T
C_STORE_ID as 店仓ID,
M_PRODUCT_ID as 产品ID,
VALUE1 as 颜色,
VALUE2 as 尺码,
min(CHANGEDATE ) as 首次入库日期,
qty as 首次入库数量
FROM
dbo.FA_STORAGE_FTP
INNER JOIN dbo.M_ATTRIBUTESETINSTANCE ON FA_STORAGE_FTP.M_ATTRIBUTESETINSTANCE_ID = dbo.M_ATTRIBUTESETINSTANCE.ID
group by
C_STORE_ID ,
M_PRODUCT_ID ,
VALUE1,
VALUE2 ,
qty 这里需要把数量也分组进去,这样就起步到只取第一次入库的数量,因为不同时间的数量不一样。
好像是可以用下面这种方式做,但是我又写不对。。。
SELEC T min(t.首次入库日期) as 入库日期2 ,t.首次入库数量 from
(SELEC T
C_STORE_ID as 店仓ID,
M_PRODUCT_ID as 产品ID,
VALUE1 as 颜色,
VALUE2 as 尺码,
min(CHANGEDATE ) as 首次入库日期,
qty as 首次入库数量
FROM
dbo.FA_STORAGE_FTP
INNER JOIN dbo.M_ATTRIBUTESETINSTANCE ON dbo.FA_STORAGE_FTP.M_ATTRIBUTESETINSTANCE_ID = dbo.M_ATTRIBUTESETINSTANCE.ID
) as t
GROUP BY
t.店仓ID,
t.产品ID,
t.颜色,
t.尺码
[此贴子已经被作者于2017/11/22 0:36:58编辑过]