PostgreSQL - Joins in PostgreSQL
You have two tables:
color_id | color_name
1 | Red
2 | Blue
shape_id | shape_name
1 | Circle
2 | Square
3 | Triangle
How many rows will this query return?
Colors:color_id | color_name
1 | Red
2 | Blue
Shapes:shape_id | shape_name
1 | Circle
2 | Square
3 | Triangle
How many rows will this query return?
SELECT color_name, shape_name FROM Colors CROSS JOIN Shapes;