/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

0 vote289 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote272 views1 answer
Group_concat only returns one row
SQL
0 vote279 views1 answer
Sqlite to csv statement
SQL
-1 vote301 views2 answers
Installing mysql on centos 7
SQL
1 vote249 views3 answers
Remove unique key from a table
SQL
0 vote287 views4 answers
User defined function sql
SQL
0 vote300 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote269 views1 answer
Postgresql isnull with max
SQL
1 vote293 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote273 views1 answer
Login phpmyadmin without password
SQL