Need all combinations of two sets? CROSS JOIN creates cartesian product. Example – All Size/Color Combinations: — Sizes table: S, M, L — Colors table: Red, Blue, Green SELECT s.size, c.color FROM Sizes s CROSS JOIN Colors c; — Result (9 combinations): — S, Red — S, Blue — S, Green — M, Red — […]