/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 vote114 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote128 views1 answer
Empty table sqlite
SQL
4 votes119 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
3 votes117 views1 answer
Postgresql if null then 0
SQL
0 vote119 views1 answer
How to retrive the today date sql
SQL
2 votes151 views1 answer
Python sql
SQL
15 votes224 views2 answers
How to sort names in alphabetical order in sql
SQL
-1 vote119 views5 answers
Operator in sql
SQL
0 vote136 views1 answer
Mysql get hour from datetime
SQL
0 vote113 views1 answer
Postgresql parse json array
SQL