DB2 Outer and Inner Joins

Inner Join:

SELECT A.N_SOCSEC, A.M_EMPLEE, A.N_STATE, B.N_PLANT
FROM TCO88001 A, TCO88002 B
WHERE A.N_SOCSEC = B.N_SOCSEC

Results Table:

N_SOCSEC	M_EMPLEE	N_STATE	N_PLANT
111-11-1111	JOHN DOE	NC	0973
222-22-2222	MARY SMITH	SC	0744

Left Outer Join:

SELECT A.N_SOCSEC, A.M_EMPLEE, A.N_STATE, B.N_PLANT
FROM TCO88001 A LEFT OUTER JOIN, TCO88002 B
ON A.N_SOCSEC = B.N_SOCSEC

Results Table:

N_SOCSEC	M_EMPLEE	N_STATE	N_PLANT
111-11-1111	JOHN DOE	NC	0973
222-22-2222	MARY SMITH	SC	0744
333-33-3333	JANE DOE	NY

Right Outer Join:
SELECT A.N_SOCSEC, A.M_EMPLEE, A.N_STATE, B.N_PLANT
FROM TCO88001 A RIGHT OUTER JOIN, TCO88002 B
ON A.N_SOCSEC = B.N_SOCSEC

Results Table:

N_SOCSEC	M_EMPLEE	N_STATE	N_PLANT
111-11-1111	JOHN DOE	NC	0973
222-22-2222	MARY SMITH	SC	0744
444-44-4444			0977

Full Outer Join:

SELECT A.N_SOCSEC, A.M_EMPLEE, A.N_STATE, B.N_PLANT
FROM TCO88001 A FULL OUTER JOIN, TCO88002 B
ON A.N_SOCSEC = B.N_SOCSEC Results Table:

N_SOCSEC	M_EMPLEE	N_STATE	N_PLANT
111-11-1111	JOHN DOE	NC	0973
222-22-2222	MARY SMITH	SC	0744
333-33-3333	JANE DOE	NY
444-44-4444			0977