A small application of full join

Code
Create   Table Table1 (PID Int , Product Varchar ( 20 ), Inputnum Int )
Go
Insert   Into Table1 Select   1 , ' A ' , 20
Insert   Into Table1 Select   3 , ' C ' , 10
Insert   Into Table1 Select   5 , ' E ' , 30
Create   Table Table2 (PID Int , Product Varchar ( 20 ), Outputnum Int )
Go
Insert   Into Table 2 Select   1 , ' A ' , 30
Insert   Into Table 2 Select   2 , ' B ' , 8
Insert   Into Table 2 Select   4 , ' D ' , 15  
Go
Select   Isnull (T1.pid, t2.pid) As PID, Isnull (T1.product, t2.product) As Product, Isnull (Inputnum, 0 ) As Inputnum, Isnull (Outputnum, 0 ) As Outputnum
From Table1 T1 Full   Join Table2 T2
On T1.pid = T2.pid
Order   By PID
Go
Drop   Table Table1, Table2
Go

/* Result
PID product inputnum outputnum
-----------------------------------------------------
1 A 20 30
2 B 0 8
3 C 10 0
4 D 0 15
5 E 30 0