Rock Paper Scissors - Schere Stein Papier Cross Join SQL

rock-paper-scissors.sql.md

SQL Fiddle

MySQL 5.6 Schema Setup:

CREATE TABLE symbols (
  symbol CHAR(12)
);

INSERT INTO symbols (symbol) VALUES
('rock'),
('paper'),
('scissors');

Query 1:

SELECT *
FROM symbols alias1
CROSS JOIN symbols alias2

Results:

|   symbol |   symbol |
|----------|----------|
|     rock |     rock |
|    paper |     rock |
| scissors |     rock |
|     rock |    paper |
|    paper |    paper |
| scissors |    paper |
|     rock | scissors |
|    paper | scissors |
| scissors | scissors |