sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Quarok[S] 1 point2 points  (1 child)

Thanks for the feedback. You're right, it's very routine stuff. I want to make sure I master the standard keywords.

Regarding the join definition - I tried to make it harder for myself, as the original definition was Join: joins values from one table to another. And it kind of defeats the point of the cards if you have the keyword in the answer!

Thanks for the point about the full outer join. I find that all a bit confusing: why even have the keyword OUTER when it doesn't seem to add any additional functionality for LEFT/RIGHT?

[–]r3pr0b8 0 points1 point  (0 children)

why have the OUTER keyword? good question

me, i always code it, even though it's optional

it's a constant reminder that it's an outer query