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 is the use of RDBMS?

579

Do you know what is sql injection?

537

What are magic tables in sql server?

617

Define master database?

569

How to apply filtering criteria at group level with the having clause in ms sql server?

549

How efficient you are in oracle and SQL server?

628

What you can do to delete a table without the delete trigger firing?

512

Tell me what do we need queues in sql service broker?

508

What is SQL Azure Fabric?

Can two tables share a primary key?

507

What are data regions?

What is table value parameters (tvp)?

527

What is clustered vs nonclustered index?

502

How to modify existing triggers using "alter trigger"?

518

how to overcome kernel isssues

1165