How to Join Unrelated SQL Tables

Paopatsin/ August 22, 2020/ Database, MS SQL, Technology

Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64) Command: SELECT d.*, p.* FROM [AdventureWorks2016].[HumanResources].[Department] d JOIN [AdventureWorks2016].[Person].[Person] p ON 1 = 1 Steps and Sample Usage: Open and log into your SQL Management Studio Open a New Query Windows or (CTRL+N) Run the following commands: (Copy and Paste the code block to your Query Window)

Read More