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 is compression - row-level and page-level compression?

539

How you provide security to cube? : sql server analysis services, ssas

551

Explain hostprotectionattribute in sql server 2005?

607

How to execute stored procedure and set temp table in sql server?

564

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

470

Explain primary key and foreign key constraints?

527

What is a ddl statement?

521

Describe the left outer join & right outer join. : sql server database administration

594

What is an indice?

582

Explain boyce and codd normal form(bcnf)?

541

Can we write ddl in trigger?

501

If a table does not have a unique index, can a cursor be opened on it?

518

Differentiate between SQL and ORACLE joins and write their syntax.

598

What are the advantages of using cte?

561

What is difference between equi join and inner join?

486