One to one record mapping without any common column between two tables in SQL server
how to merger two tables without using Common column
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Amit Kumar SinghPosted Mar 11, 2016, 2:11 AM
SELECT column1, column2FROM table1
WHERE column1 IN
(
SELECT column1
FROM table1
INTERSECT
SELECT column1
FROM table2
)
Riddhi ValechaPosted Mar 11, 2016, 5:46 AM
This means - column1 is common in both the tables.SELECT column1, column2FROM table1
WHERE column1 IN
(
SELECT column1
FROM table1
INTERSECT
SELECT column1
FROM table2
)
kumar yogaPosted Mar 11, 2016, 4:00 AM
Amit Kumar SinghPosted Mar 11, 2016, 3:58 AM
Riddhi ValechaPosted Mar 11, 2016, 2:45 AM