SQL Server query

Question

I have two table Table1 Col1 col2 col3 col4 1 2 3 4 Table2 Col1 col2 col3 col4 5. 6. 7. 8 By combining two table I need a SQL server query to return result like this Col1 col2 col3 col4 1 2 3. 4 5. 6 7 8 Please help meits urgent for my project

Shashangka Shekhar · Answer

Use UNION to concatenate rows. SELECT [Col1] [Col2] [Col3] [Col4] FROM [dbo].[Table_1] UNION SELECT [Col1] [Col2] [Col3] [Col4] FROM [dbo].[Table_2] Result:

Amit Gupta · Answer

Hey Use SQL Query Builder to create any type of query Open SSMS -> Click New Query -> press CTRL + SHIFT + Q Add your tables make relationship between the tables select your fields All done!! Good Luck

Amit Gupta · Answer

Then skip the relationship and proceed with the next step

priyanka singh · Answer

There is no relationship between this table.as asked my my interviewers.plz suggest me thishow is it possible