Topics

• Join
• Variables
• ORDER BY
• Use of TEMP Table
• Sorting/ordering rows

Examples

• Global Temp Table
• Updating variables by selecting from a table
• Accidentally turning an outer join into an inner join
• Order by Case
• Dropping temp tables
• Custom Ordering