Quiz: Logical Joins in TSQL

For the purposes of this quiz…

Assume that every Order can have only one invoice at the most, and vice versa. (Or if you’re of a more scholarly bent, the degree of relationship is 1:1.)

Quiz: Logical Joins in TSQL ๐Ÿค

Bringing tables together in an ANSI kinda way

Want to play around with these joins?

Here’s the code from the examples.

Brush up on the official documentation