its very easy yaar who has written this? just use union operator as in set

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 / goutam dey

Answer Posted / goutam dey

its very easy yaar who has written this?
just use union operator as in set theory in mathematics
hahaha...

Is This Answer Correct ?

1 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What are the properties of the transaction?

968

What are click through reports?

138

How to get a list of columns in a view using the "sp_columns" stored procedure?

985

How to sort the query output with order by clauses in ms sql server?

983

Can the query output be sorted by multiple columns in ms sql server?

935

What is trigger explain with program?

931

Explain about SQLOS?

946

What is index fragmentation in ms sql server?

1023

What is the purpose of the model database?

963

What is field with example?

869

What function does a database engine serve in the sql server?

985

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

911

How can you list all the columns in a database?

885

What is repeatable read?

934

What is difference between stored procedure and user defined function?

1029