/SQL/How to know if table in rigt or left in sql

How to know if table in rigt or left in sql

-- People:           -- Car
id | name            owner_id | model
---+------------     ---------+------------
1  | Paul            1        | Ferrari
2  | Nancy           2        | Porsche
3  | Arthur          NULL     | Lamborghini
4  | Alfred          10       | Maserati

> select people.name, car.model from people join car on car.owner_id=people.id;

name     | model
---------+--------------
Paul     | Ferrari
Nancy    | Porsche
2 record(s) found

> select people.name, car.model from people left join car on 
  car.owner_id=people.id;

name     | model
---------+--------------
Paul     | Ferrari
Nancy    | Porsche
Arthur   | NULL
Alfred   | NULL     
4 record(s) found

> select people.name, car.model from people left join car on 
  people.id = car.owner_id;

name     | model
---------+--------------
Paul     | Ferrari
Nancy    | Porsche
Arthur   | NULL
Alfred   | NULL     
4 record(s) found

Source: stackoverflow.com

Similar codes

3 votes217 views3 answers
Remove all spaces from string sql
SQL
0 vote236 views1 answer
Excel export from sql using python
SQL
2 votes224 views1 answer
Sql server find table name
SQL
13 votes240 views2 answers
Sql join 3 tables
SQL
18 votes235 views3 answers
Mysql add column default value
SQL
0 vote186 views1 answer
Postgres delete where id in
SQL
0 vote219 views1 answer
Sql drop default
SQL
3 votes246 views1 answer
Sql online test questions and answers
SQL
0 vote218 views2 answers
Postgresql create role
SQL
0 vote227 views1 answer
Postgresql create user roles
SQL