select * from table1 union select * from table2

There is a table1 with records (1,2,3,4,5,6) and table2
with records (4,5,6,7,8,9).write a query so as to get the
result as 1,2,3,4,5,6,7,8,9

Question Posted / anil

Answer Posted / anil

select * from table1

union

select * from table2

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Which joins are sql server default?

1072

What is perspective, have you ever created perspective? : sql server analysis services, ssas

962

What is the purpose of floor function?

1095

How to sort query output in descending order in ms sql server?

985

How to delete an existing row with delete statements in ms sql server?

1153

In which sql server version report builder introduced?

152

How to retrieve error messages using mssql_get_last_message()?

1107

What is the user of Primary key?

1032

What is right outer join in sql server joins?

1222

What is deploy, process and build? : sql server analysis services, ssas

1157

What are the system database in sql server 2005?

1099

explain databases and sql server databases architecture? : Sql server database administration

1016

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1248

What are sub reports?

208

How do you open a cluster administrator?

1098