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

How many database files are there in sql server 2000?what are they?

996

What does it mean to normalize a database and why would you do it?

954

What is Cross Join and in which scenario do we use Cross Join?

988

What is SQL Azure?

105

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1915

What are partitioned views and distributed partitioned views?

988

What is a bit datatype?

941

What is dknf in normalization form?

1000

Differentiate between delete and truncate.

1014

How do I partition a table in sql server?

999

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1020

How to select all columns of all rows from a table with a select statement in ms sql server?

1061

How to declare and use cursor variables?

1101

Explain the truncate command? : SQL Server Architecture

1112

What are the kinds of subquery?

969