Union gives the result in two records We have to use cross join like bel

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 / guru

Answer Posted / guru

Union gives the result in two records

We have to use cross join like below

select * from table1,table2

Is This Answer Correct ?

0 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What are the different types of triggers in SQL SERVER?

1047

What is the difference between truncate and delete commands?

1001

What is difference between clustered index and non clustered index?

1027

How to turn off warning messages during php execution?

981

Please differentiate between a local and a global temporary table?

948

What is the need for indexing?

886

What are out-of-range errors with date and time literals?

965

Why de-normalization required?

940

Define left outer join in sql server joins?

905

What is normalization? Explain its different types?

1037

Can you explain important index characteristics?

937

How to change a login name in ms sql server?

1023

What do you mean by an execution plan? How would you view it?

868

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

924

Call by value and call by reference in procedure and function, with NOCOPY.

1244