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 acid db?

868

How many columns can we include on clustered index ?

968

How can I tell if sql server is 32 or 64 bit?

937

can a database be shrunk with users active? : Sql server administration

988

How to call a function from a stored procedure in SQL Server ?

1002

Do you know query execution plan?

1147

State the difference between union and union all?

918

What is difference between global temporary tables and local temporary tables?

1211

What is an example of a primary key?

957

What is database black box testing?

1017

Explain sql delete command?

1028

How do you send email on SQL Server?

1040

How to check if a table is being used in sql server?

944

what purpose does the model database serve? : Sql server database administration

957

How to delete multiple rows with one delete statement in ms sql server?

982