/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 vote136 views1 answer
Mysql drop vs delete
SQL
0 vote142 views1 answer
Sql log file inof
SQL
0 vote120 views1 answer
Mysql return column names when table is empty
SQL
5 votes124 views1 answer
Find table from column name in sql
SQL
4 votes154 views1 answer
Mysql delete last row
SQL
6 votes159 views5 answers
Oracle list tablespaces
SQL
0 vote112 views1 answer
Materialized view redshift
SQL
1 vote133 views1 answer
Mysql change root mysql_native_password
SQL
12 votes120 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote129 views1 answer
Ajouter une clé etrangere mysql
SQL