How to do a cross_ join in SQL Server? [closed]-CodePudding

I have two separate entities and I have implemented some calculations while writing a script for that separate entity I use inner join, left join and I am unable to do a cross join in that entity.

Kindly provide a solution.

CodePudding user response：

SELECT *
FROM   A
 CROSS
  JOIN B
;

CodePudding user response：

SELECT
*
FROM [Schema].[TableA] A
CROSS JOIN [Schema].[TableB] B