Outer join di MS SQL Server 2000?

Question

Assume I have two tables:

Table name: coachs

code | from
----------------
0A | Australia
0B | Beligium

Table name: players

code | from
----------------
0C | Columbia
0D | Denmark

I want to join these tables above, into one table or one view:

code | from
----------------
0A | Australia
0B | Beligium
0C | Columbia
0D | Denmark

How to perform this? Step by step please... I'm a begginer. Thank you.

Answer 1

select code, [from] from coachs
union all
select code, [from] from players

If you MUST do it with a outer join... you can do this, which should give you the same results. The first way is preferable.

select
isnull(coachs.code, players.code) as code,
isnull(coachs.[from], players.[from]) as [from]
from coachs full join players on 1=0

Answer 2

assuming that you have two tables with exactly same column, I would suggest that you perform UNION instead of OUTER JOIN.

Select * from coachs UNION Select * from players;

would result like what you specify. The alternative would be using SELECT INTO statements for each table to fill the data into the target table and do normal query :

Select * from target;