SQL从两列和两张表追加不同的值

这给出了预期的结果：

with cte1 as (Select distinct account from test),cte2 as (Select distinct article from test)Select * from cte1 cross join cte2

架构：

Create table test(account int, article int);Insert into test values(1,1);Insert into test values(1,2);Insert into test values(2,3);