There is also CROSS JOIN, where every combination of rows from both tables are joined with each other. But I feel like I know, why you left that one of your list. It is a rare occurence (at least for me), that I want all rows of two tables cross joined.
The only case I used it so far, was to join a table with another, that contained only one row.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
There is also CROSS JOIN, where every combination of rows from both tables are joined with each other. But I feel like I know, why you left that one of your list. It is a rare occurence (at least for me), that I want all rows of two tables cross joined.
The only case I used it so far, was to join a table with another, that contained only one row.