SELECT t1.*,t2.*
FROM table1 t1
INNER JOIN table2 t2
ON t2.ID_column = t1.ID_Column

quote:

---

Originally posted by visakh16

so your result table (third3) will have all columns from both tables horizontally? or you want data to be merged vertically?

If former it should simply be

SELECT t1.*,t2.*
FROM table1 t1
INNER JOIN table2 t2
ON t2.ID_column = t1.ID_Column

We have more columns with the same name as the title (Id, name an others). So if its possible, the query will have to recognize the columns with the same name and copy the data from one of the two tables. (if not i will do it manually)

I want to merge the columns horizontally, in order to have every single column in the same height, so if we have 15 columns and we merge 4 more, we will have all the 19 columns starting at the same height.

Im sorry for asking, im not a pro of the SQL as you can see, but, in that query :

SELECT t1.*,t2.*
FROM table1 t1
INNER JOIN table2 t2
ON t2.ID_column = t1.ID_Column

* ? what does it means, the column name that i want select from the table?
FROM table1 t1 ? From table 1 (...), I dont understand the part table 1 t1
INNER JOIN table2 t2 ? inner join table2 (...), I dont understand it the part: table2 t2

thanks
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---