Page 132 - SQL

here.

Right Anti Semi Join

Includes right rows that do not match left rows.

SELECT * FROM B WHERE Y NOT IN (SELECT X FROM A);

Y
-------
Tim
Vincent

As you can see, there is no dedicated NOT IN syntax for left vs. right anti semi join - we achieve
the effect simply by switching the table positions within SQL text.

Cross Join

A Cartesian product of all left with all right rows.

SELECT * FROM A CROSS JOIN B;

X Y
----- -------
Amy Lisa

https://riptutorial.com/ 114