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 create a view using data from another view?

903

Explain the xml support sql server extends?

982

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

968

How we can refresh the view?

1056

Explain what is lock escalation and what is its purpose?

874

Do you know query execution plan?

1073

Where are sql server usernames and passwords stored in the sql server?

1042

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

839

What is the default port for SQL Server over a firewall?

1030

What is entity data services?

1003

What are sql server procedures?

929

What is the difference between DataRow.Delete() and DataRow.Remove()?

1166

Call by value and call by reference in procedure and function, with NOCOPY.

1245

What are the different acid properties?

1013

What is lock escalation and what is its purpose?

921