select inv.单号 as 单号,inv.日期 as 日期,inv.单据类型 as 单据类型,inv.出入库类型 as 出入库类型,inv.仓库ID as 仓库ID,invd.材料ID as 商品ID, invd.数量
from 出入库表 inv
inner join 出入库详情表 invd
on inv.ID=invd.出入库ID
是用的内置数据库,哪位能帮改一下吗,谢谢了
SELECT
inv.单号 as 单号,
inv.日期 as 日期,
inv.单据类型 as 单据类型,
inv.出入库类型 as 出入库类型,
inv.仓库ID as 仓库ID,
invd.材料ID as 商品ID,
CAST(invd.数量 AS REAL) as 数量
FROM
出入库表 inv
INNER JOIN 出入库详情表 invd ON inv.ID = invd.出入库ID;