SELECT (SELECT Count([资产表1].[科目编码]) AS AutoNum FROM 资产表1 WHERE (((资产表1.科目编码)<=资产表1_1.科目编码));) AS 序号, 资产表1.款名称, 资产表1.款编码, 资产表1.类别, 资产表1.类名称, 资产表1.科目, 资产表1.科目编码, 资产表1.年初数, 资产表1.期末数, 资产表1.年度, 资产表1.月份 INTO 资产表3
FROM 资产表1 INNER JOIN 资产表1 AS 资产表1_1 ON 资产表1.科目编码 = 资产表1_1.科目编码
ORDER BY 资产表1.科目编码;