/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

1 vote257 views1 answer
Last 6 months postgresql
SQL
2 votes269 views1 answer
Column names in oracle sql
SQL
0 vote234 views1 answer
Mysql workbench search all tables
SQL
1 vote266 views1 answer
Join first name and last name sql
SQL
-1 vote271 views5 answers
Convert sql to linq query online
SQL
1 vote294 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote249 views1 answer
Select count postgres double row count > 1
SQL
1 vote229 views1 answer
Psql show with user is logged in
SQL
0 vote257 views1 answer
Plsql find location of procedure
SQL
13 votes259 views3 answers
Sql select from multiple tables without join
SQL