34,593
社区成员
发帖
与我相关
我的任务
分享
;WITH 仓库表(ID, [NO], NAME) AS
(
SELECT 1, 01, '仓库1' UNION ALL
SELECT 2, 02, '仓库2'
)
,商品表(ID, ITEM_NO, ITEM_NAME) AS
(
SELECT 5, 201, '商品1' UNION ALL
SELECT 6, 202, '商品2'
)
SELECT A.NO, A.NAME, B.ITEM_NO, B.ITEM_NAME
FROM 仓库表 AS A
CROSS JOIN 商品表 AS B
select a.[NO],a.NAME,b.ITEM_NO,b.ITEM_NAME
from 仓库表 a left JOIN 商品表 b
on 1=1