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 |