select isnull(a.id,b.id) from table1 a full outer join table2 b on a.id=b

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

Answer Posted / jagadeesh

select isnull(a.id,b.id) from table1 a
full outer join table2 b
on a.id=b.id

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the different types of subquery?

712

How raid can influence database performance?

676

How to generate create view script on an existing view?

646

What is linked report?

How to define output parameters in stored procedures?

625

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

556

What is SQL Azure Fabric?

100

What are the two modes of authentication in sql server?

606

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1720

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

119

How is sql server used?

623

What is fill factor and pad index?

650

How to create and drop temp table in sql server?

666

Can you explain the disadvantages/limitation of the cursor?

582

What is difference between cte and view?

605