News for hackers. Stuff that matters.

A comment on Challenges students face when learning to work with relational databases and SQL. Parent comment

Re:Challenges students face when learning to work with relat... by AdrianB1 on Sunday August 29, 2021 @05:50PM (#28350784)
Remembering which join does what is easy: inner joins strictly joins the tables, left takes all on left (first table), right takes all on right (second table), outer (or cross) join are so rarely used you don't need to memorize.
[ Parent | on HN ]
Re:Challenges students face when learning to work with relat... by Semaphor on Monday August 30, 2021 @02:17AM (#28353197)
> outer (or cross) join are so rarely used you don't need to memorize.

I’d say they are more important to know than right joins.

[ Parent | on HN ]