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 service broker? : sql server database administration

1032

How do I open a .db file?

1083

How do I shrink an ldf file?

1040

Tell me what are the essential components of sql server service broker?

991

Can two tables share the same primary key?

987

What is store procedure? How do they work? When do you use?

1000

Explain transaction server distributed transaction?

1039

What is enhanced database mirroring in sql server 2008?

1037

Tell me what is the significance of null value and why should we avoid permitting null values?

1044

explain declarative management framework (dmf) in sql server 2008?

1044

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1001

Write SQL queries on Self Join and Inner Join.

1219

What is default constraint?

1054

Differentiate between mongodb vs. Sql server?

1143

How to Sync Two SQL Azure Databases?

121