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 to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

887

What is 2nf normalization?

1001

What is model database in sql server?

1032

What is correlated subquery in sql server?

1048

What is the difference between lock, block and deadlock? : sql server database administration

1024

What does sql server mean?

1034

What are the steps to follow to configure SQL*Net?

1018

Write a query to find 5th highest amount paid from the customer table.

920

What is apply operator in sql?

993

What is a cube? : sql server analysis services, ssas

979

How many levels of sp nesting is possible?

1038

What is exporting utility?

991

What is database white box testing?

1107

What is collation?

1125

Which is the main third-party tool used in sql server?

924