Table Joins

Table Joins

Menu Table Joins

Table Joins

Furthering the research into the use of a Relational Database on a website, the subject of table joins came back into view.

Having worked on a few databases in the past I think that this something that I need to have a continued interest. I don't need to but I feel that it is something that I would like to play around with.

If I ever want to index my pages and make a search for information that is contained on them I may want to use some SQL to do so.

Top

The Outer Join

The Diffen website says:

" An outer join returns a set of records (or rows) that include what an inner join would return but also includes other rows for which no corresponding match is found in the other table.

There are three types of outer joins:

Left Outer Join (or Left Join)
Right Outer Join (or Right Join)
Full Outer Join (or Full Join)

Table Joins

Links