/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

36 votes196 views6 answers
Delete from where sql
SQL
0 vote188 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote200 views1 answer
Sql server count all tables rows
SQL
11 votes199 views3 answers
How to get last row of table in sql
SQL
16 votes188 views1 answer
Mysql reset auto increment value
SQL
18 votes196 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote237 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
1 vote293 views1 answer
Oracle datafile max size 32gb
SQL
3 votes187 views1 answer
Only join in sql
SQL
0 vote248 views1 answer
Sql ssrs
SQL