11 replies

MySQL Self Join Table

Can you help me understand JOIN a bit more

SELECT *
FROM Weather AS yesterday 
JOIN Weather AS today;

Why is the output of this starts with
id
4
3
2
1

SELECT *
FROM Weather AS yesterday 
JOIN Weather AS today;

Why is the output of this starts with
id
4
3
2
1

SELECT *
FROM Weather AS yesterday 
JOIN Weather AS today;

Why is the output of this starts with
id
4
3
2
1

SELECT *
FROM Weather AS yesterday 
JOIN Weather AS today;

Why is the output of this starts with
id
4
3
2
1