The Self Join with ANSI Syntax
Quiz – Will both queries bring back the same Answer Set?
Answer – Will both queries bring back the same Answer Set?
Quiz – Will both queries bring back the same Answer Set?
Answer – Will both queries bring back the same Answer Set?
How would you join these two tables?
How would you join these two tables? You can’t….Yet!
An Associative Table is a Bridge that Joins Two Table
Quiz – Can you write the 3-Table Join?
Answer to Quiz – Can you write the 3-Table Join?
Answer – Can you write the 3-Table Join to ANSI Syntax?
Quiz – Can you Place the ON Clauses at the End?
Answer – Can you Place the ON Clauses at the End?
The 5-Table Join – Logical Insurance Model
Quiz - Write a Five Table Join Using ANSI Syntax
Answer - Write a Five Table Join Using ANSI Syntax
Quiz – Write a Five Table Join Using Non-ANSI Syntax
Answer - Write a Five Table Join Using Non-ANSI Syntax
Quiz –Re-Write this putting the ON clauses at the END
Answer –Re-Write this putting the ON clauses at the END
The Nexus Query Chameleon Writes the SQL for Users.
Date Functions
Date, Time, and Timestamp Keywords
Add or Subtract Days from a date
The to_char command
Conversion Functions
Conversion Function Templates
Conversion Function Templates Continued
Formatting A Date
A Summary of Math Operations on Dates
Using a Math Operation to find your Age in Years