When working in a normalized environment
When working in a normalized environment, chances are one will have to combine tables and get a result set into a table. To accomplish this task, the clause JOIN is used. Depending on what result is needed, different forms of this clause are used. They are: INNER JOIN OUTER JOIN (both LEFT and RIGHT) FULL […]