/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 vote336 views1 answer
Sql right characters
SQL
0 vote361 views1 answer
Sql server query database space available
SQL
0 vote383 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote379 views1 answer
Convert excel into sqllite db using python
SQL
4 votes407 views6 answers
Select sql
SQL
3 votes374 views1 answer
Postgres add not null to existing column
SQL
0 vote365 views1 answer
Oracle list partitions
SQL
0 vote340 views1 answer
Except in sql alchemy
SQL
40 votes404 views6 answers
Update table mysql
SQL
3 votes434 views1 answer
Apex call duration
SQL