SQL联接查询

交叉连接

SELECT C.ID D.NAME

FROM dbo.test as c

      CROSS JOIN dbo.testt as d;