SELECT ENTRY_ID AS 海关编号, D_DATE AS 申报日期, TRADE_MODE AS 监管方式, GROSS_WT AS [毛重(KG)], NET_WT AS [净重(KG)], G_NO AS 序号, G_NAME AS 商品名称, QTY_1 AS 成交数量, DECL_TOTAL AS 成交总价, TRADE_CURR AS 币制, REPLACE(REPLACE(I_E_FLAG, 'I', 'JBCE'), 'E', 'JBYE')+right(1000+CONTR_ITEM ,3)+right(10000+EXG_VERSION ,4) AS 版本号 FROM A , B 试试这个。
021220130620029063 2013-7-23 0110 749 725 1 改性尼龙塑胶粒 725 6412.63 USD JBCE0000000
021220130620029350 2013-9-12 0110 2650 2575 1 改性尼龙塑胶粒 2575 22260.88 USD JBCE0000000
021220130620029878 2013-11-5 0110 775 750 1 改性尼龙塑胶粒 750 6487.50 USD JBCE0000000
021220140620035937 2014-1-10 0110 845 800 1 改性尼龙塑胶粒 300 2655 USD JBCE0000000
021220140620035937 2014-1-10 0110 845 800 2 改性尼龙塑胶粒 500 5125 USD JBCE0000000
021220140620036067 2014-2-13 0110 523 500 1 改性尼龙塑胶粒 500 4425 USD JBCE0000000
状态对应的是I_E_FLAG
ENTRY_ID AS 海关编号, D_DATE AS 申报日期, TRADE_MODE AS 监管方式, GROSS_WT AS [毛重(KG)],
NET_WT AS [净重(KG)], G_NO AS 序号, G_NAME AS 商品名称, QTY_1 AS 成交数量,
DECL_TOTAL AS 成交总价, TRADE_CURR AS 币制,
REPLACE(REPLACE(I_E_FLAG, 'I', 'JBCE'), 'E', 'JBYE')+right(1000+CONTR_ITEM ,3)+right(10000+EXG_VERSION ,4)
AS 版本号
FROM
A ,
B 试试这个。
access 在office 2003及以后,有replace函数,估计你用的版本比较早,没有类似功能的函数
access 在office 2003及以后,有replace函数,估计你用的版本比较早,没有类似功能的函数处理了,用的SWITCH这个