Full Outer Join

Documents Table
Doc_ID Title Doc_type_id
101 Creating A Relational Database 11 
102 Using Stored Procedures 12 
103 Caching Queries  
104 Joining Tables Together 11 

Doc Types Table
type_id doc_type
11 Word
12 PDF
13 XML

SELECT doc.doc_id, doc.title, dt.doc_type
FROM tblDocuments doc, tblDocType dt
ORDER BY doc.doc_id

Full Outer Join
Title Doc Type
Creating A Relational Database Word
Creating A Relational Database PDF
Creating A Relational Database XML
Using Stored Procedures Word
Using Stored Procedures PDF
Using Stored Procedures XML
Caching Queries Word
Caching Queries PDF
Caching Queries XML
Joining Tables Together Word
Joining Tables Together PDF
Joining Tables Together XML