how to merge two tables without using Common column

Question

One to one record mapping without any common column between two tables in SQL server how to merger two tables without using Common column

Amit Singh · Answer

SELECT column1  column2 FROM table1 WHERE column1 IN ( SELECT column1 FROM table1 INTERSECT SELECT column1 FROM table2 )

Riddhi Valecha · Answer

Hi.... Query - SELECT column1  column2 FROM table1 WHERE column1 IN ( SELECT column1 FROM table1 INTERSECT SELECT column1 FROM table2 ) This means - column1 is common in both the tables. But your query was - no column is common in two tables. How did this query work ? Please explain. I am confused.

kumar yoga · Answer

thanks for the support

Amit Singh · Answer

Thanku Kumar

Riddhi Valecha · Answer

Hi..Refer examples in the links - http://stackoverflow.com/questions/1198124/combine-two-tables-that-have-no-common-fields http://sqlhints.com/2013/09/07/joining-two-tables-without-any-common-column-between-them-sql-server/