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 is the difference between push and pull subscription? : sql server replication

1175

What do you need to connect php to sql server?

1062

What do you mean by table and field in sql?

980

What is the purpose of data source?

979

Is it ok to shrink transaction log?

953

What is the difference between a clustered index and a non-clustered index?

941

Can we return Data from 4(more than 1) tables in stored procedure?

1019

Define cursor locking

967

What are the basic features of a trigger in ms sql server?

1139

Explain how to integrate the ssrs reports in application?

972

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

998

Explain filestream storage of sql server 2008?

975

What are the new data types are introduced in sql 2000?

868

What is explicit mode in sql server?

1028

What are parameterized reports? What are cascading parameters in ssrs reports?

154