/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 vote290 views1 answer
Changer un mot de passe mysql
SQL
0 vote320 views1 answer
Mysql récupérer le code création de vue
SQL
1 vote298 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote671 views1 answer
Sql field equals multiple values
SQL
1 vote319 views1 answer
Create another table from existing table sql oracle
SQL
0 vote322 views1 answer
Oracle swap partition
SQL
0 vote314 views1 answer
Sql get highest date from 3 tabels
SQL
1 vote317 views3 answers
How to filter repeated same result using sql query
SQL
0 vote331 views1 answer
Neo4j command to run script file
SQL
0 vote317 views1 answer
Connect by query in oracle
SQL